4 Replies Latest reply: Mar 3, 2017 1:12 PM by Rupam Das RSS

    doubt in debtors application

    Gulshan Rohilla

      I have a dataset of Debtors. Two tables or sheets are there first is Invoice table which consists of invoice amount & credit notes raised on individual invoice no. and the second is Collections which consists of collection done on particular invoice no.

      BRD are:-

      1.) To calculate the outstanding amount  :- which I did by using the Set analysis on the frontend. now i want bucketing on the outstanding amount but i am not able to do that because i have not calculated the outstanding amount on the backend & Set analysis only works on the frontend. So can You please suggest how can i do bucketing now.

       

      I have attached My App and the dataset below :-

      i want this type of bucketing :-

      bucket.PNG

      Can anyone please help me in this...