0

NL First Sum

Jet Reports Historic Posts

November 18, 2016 08:41

None

Follow

Hi,

I tried to get a sum of field "Amount", from the first entry of field "Level " (the red marked entries)
Nr.               Level   Amount
25117137T   003     0
25117137T   008     308,7
25117137T   008     16,58
25117137T   008     27,46
25117137T   010     3.166,49
25117137T   010     170,09
25117137T   012     200,33
25117137T   015     1.192,00
25117137T   015     64,03

=NL("SUM";"tablename";"Amount";"Level";"003|008|010|012|014|015";"Nr.";"25117137T")

What I'll have to do, to get only the red marked entries?

Thanks.
Andreas

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts November 18, 2016 19:14

  Hi Andreas -
  
  Before we go down the path of a rather complex method (that would require that there be a 'record number' field in the table - and I still need to figure out how to reference it)…
  
  Could this extremely simply method work for you?
  
  
  
  Alternately, is there some other field in the table that you could use to uniquely identify the first record for each level?