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_MuhammadThanks will take a look and also wondering to see if anyone else reply on this and how they will solve it.

  • 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.