Regarding Balance Amount Calculation

[#1]

Hello Friends,

I appreciate your time.  Kindly let me know the best approach to calculate the following Balance Amount.

  Customers   Milk_In_lts   Rate(Rs.)     Date             Total         AmountPaid        Balance

   Cus1           10                    25          1/1/15               250        100                           150

   Cus1           15                    20          2/1/15               300        150                            300**

(Need to calculate and maintain this  Balance  amount for all the customers)

Please let me know

Kind regards,

Kiruthi

[MarcoWedel]

Hi,

I'm currently working on a solution to only show the latest balance.

Maybe in the meantime you can mark any reply correct that actually answered your initial question.

thanks

regards

Marco

[MarcoWedel]

Hi,

one solution to only show current balances could be:

hope this helps

regards

Marco

[#4]

Hello Macro,

I sincerely appreciate your time and help!!

Thanks, I got it :-)))

Kiru