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 ?

Snapshot
John-S PretoriusTechnical Service Manager, Mid-AtlanticAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Minimum and maximum are for the values so if the values are 1 and 2 the minimum will generally be 1 and the maximum 2.

Try this

In the group header add a formula
WhilePrintingRecords;
Global NumberVar FirstValue;
FirstValue := If Exit then 2  else 1;
""

In the group footer you can show the value with

WhilePrintingRecords;
Global NumberVar FirstValue;
FirstValue

The last value will be the value of your formula

mlmcc
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
Thank you, I really tried my best for days but just could not come up with anything - so much to learn.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.