Agewise analysis

Hi Sailaja,

If you have ageing details in your report and if you need to categorize the ageing in difference bucket, you can use the below formula :

0-30  : sumifs(amount column,ageing column,"<=30")

31-60 : sumifs(amount column,ageing column,">30",ageing column,"<=60")

................... 

Like above, you can add ageing bucket as per your requirement by using sumifs formula.

Hope the above will provide answer for your query. 

thank u bharati,,it has been very useful!!