Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to calculate the sum of the "Amount" field based on the number of delinquent days, grouped by month.
Please see below
Table fields
Amount 1/14 2/14 3/14 4/14
$100 4 34 64 90
$80 45 65 71 85
etc.
Desired output chart
Month 0-30 30-60 60-90
1/14 $100 $80 $0
2/14 $0 $100 $80
3/14 $0 $0 $180
4/14 $0 $0 $180
What should be the dimension and expression ?
Thank you
Bassam
It looked that you need to transform your data into a normal data-structure per The Crosstable Load and then you could use Month and class(aggr(sum(Amount), Month), 30) as dimensions and sum(Amount) as expression.
- Marcus
It looked that you need to transform your data into a normal data-structure per The Crosstable Load and then you could use Month and class(aggr(sum(Amount), Month), 30) as dimensions and sum(Amount) as expression.
- Marcus