Hi,
I'm setting up a GridView that will look similar to the Overdue Receivables Report in AR.

This is the formula that I have right now in the calculated column for the "Current" amount:

if ({Due Date}>={As Of Date},{Current Amt},0)

I have made different kinds of changes to the formula but it does not have the same total as the "Current" column from the AR report.

Is this a wrong formula to use for that column or am I missing something?