• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 486
  • Last Modified:

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
0
John-S Pretorius
Asked:
John-S Pretorius
1 Solution
 
mlmccCommented:
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now