Forum Discussion

jmcph's avatar
jmcph
Helper III
3 years ago
Solved

Need computation breakdown

Need Help! I wish to compute for Principal and Interest. My computation is relatively simple, Interest will be computed only if total collection EXCEEDS the loan amount.    My sample data are:    ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    jmcph ,New measure assuming other are measure

    Principal= if( [cummulative collection] >  [cummulative loan amount], [collection] - ([cummulative collection] - [cummulative loan amount]) , blank())

     

    Interest = if( [cummulative collection] >  [cummulative loan amount], ([cummulative collection] - [cummulative loan amount]) , blank())

     

    for else part I have used blank, but you can use other formula

amitchandak's avatar
amitchandak
Super User
3 years ago

jmcph ,New measure assuming other are measure

Principal= if( [cummulative collection] >  [cummulative loan amount], [collection] - ([cummulative collection] - [cummulative loan amount]) , blank())

 

Interest = if( [cummulative collection] >  [cummulative loan amount], ([cummulative collection] - [cummulative loan amount]) , blank())

 

for else part I have used blank, but you can use other formula