Forum Discussion

parry2k's avatar
parry2k
Super User
8 years ago
Solved

Balance value calculation

Phil_SeamarkZubair_Muhammad Anonymous Vvelarde MFelix   Hello fellow datanuts, Attached is a sheet to calculate the value of balance and explained in "value calculation formula" how the value will ...
Need Help
parry2k's avatar
parry2k
Super User
8 years ago

Zubair_Muhammadi would like to accept your solution but still waiting on other experts on how they will approach it? 

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

parry2k

 

I still trying to understand the logic involved in this.

 

Don't get it yet

 

Regards

 

Victor

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    Vvelardethanks for looking into it, basically it take the balance and go backward until balance quantity is zero, in other words, allocate balance quantity backward to the "in" Quantity and multiply allocated quantity with the rate.