Latest month calculation field gives error when used in another calculation field

Hi, I am trying to use the latest month of the calendar date and use that number in another calculated field.
Any ideas to resolve this issue would be appreciated

@Tina1 -
Try adding an aggregation around Prior Month Billing Actuals. Since latest month has aggregated values, then all fields in the expression must be aggregated. You can use SUM({Prior Billing Actuals}) or MIN, MAX, AVG, etc.

1 Like