Calculation for Payment Overdue by Buckets 30 days, 60 days, 90 days.

[mbrahman]

Dear Expert,

I have successfully created a Statement Of Account and we were happy with it, until our Accountant requested for overdue payments to be shown in the buckets of >30 days, >60 days, >90 days, >120 days etc.

I have the following C# script, how can I insert this into contitions so that the overdue invoices are accumulated into the right bucket fields. I have created 5 decimal fields = Buk30, Buk 60, Buk90, Buk120 and Buk160 Please....................

if (Days > 30 && Days 60 && Days 90 && Days 120 && Days 160)
{
Amount += Buk160
}
else
{
// whatever not within the range;
}

[Edward]

Please define an additional calculated column in your DataSource in the Dictionary of the report. In the Value box of the field you can calculate a desired value.

Thank you.

[mbrahman]

Hi Edward, :biggrin:

Thank you for the tip, I have tried but getting no where. Could you kindly give me an example based on my code please, would really appreciate your help.

Regards,
:emb:

[Edward]

Please see the following sample report. The calculated column is named Amount. Its value depends on the Region column.

You may open this report in the Demo.exe sample application from the standard delivery.

Thank you.