Good evening,
Hopefully you can help me!
I have some fields summed up bases on some conditions. These conditions include previous() and next() functions to summing this field later is not possible.
Therefor I have made a formula using a variable to define when to add the value or when not to
Then I have made a new formula which on different conditions sums up the previous formula.
This all works great. Only in the group footer I want to show the result of this last formula.
Because this sum is based on a variable and the formula is shown in my details records but also in my group footer it will sum the last record twice.
How can I add the condition in my formula to recognize that the current action is not in a detail record but in a group record, so it does not need to re-calculate?
Many thanks for your troubles!
Regards,
Mike