Link to home
Start Free TrialLog in
Avatar of John-S Pretorius
John-S PretoriusFlag for United States of America

asked on

Show first transaction in group footer

I am grouping by 'roomnumbers' (Number) and have Entry/Exit data defined by a device type. I'm trying to show in a formula placed in the group footer what the first device type used was but my result is not as expected - See image below. I have a @ movement formula which shows the number 2 for a exit and the number 1 for an entry and when I use a formula : @test (minimum {movement,roomnumber} I am expecting a number 2 (as it is an exit in the data) but instead I get a 1, when I use a second formula @test2 (minimum{time,roomnumber} I do get the expected first transaction. (time)

Is there way to show the first movement type (number) in the footer ?

User generated image
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of John-S Pretorius

ASKER

Thank you, I really tried my best for days but just could not come up with anything - so much to learn.