Post Author: jmmj
CA Forum: Formula
Does anyone can provide the formula for the YTD amount? For example, the YTD amount for the last line of the same description which is the sum of the lines plus the balance forward. All other YTD amounts are zero in the table behind the scenes.
Description Current Amount YTD Amount
Desc1 500 0
Desc1 500 1000
Desc2 100 100
But I want the report shown:
Desc1 500 500
Desc1 500 1000
Desc2 100 100
Thanks!
Post Author: V361
CA Forum: Formula
Use a running total, Field to summarize will be current amount, you don't need to change the evaluate and reset, unless you are running this as part of a group. if so, you may need to evalutate or reset on change of group....
Add a comment