Forum Discussion

valeriydik's avatar
valeriydik
Regular Visitor
8 years ago

Decreasing running total

Hi everyone! I'm developing visual to calculate loss given default (LGD) for the 91+/181+ default generations (separately). I'm stuck on the metric algorithm itself. In Excel, this is currently done...
Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

valeriydik

 

Hi can you share a Dummy PBIX and a XLS (to review the formula and what rows and columns use in the visual?

 

You can upload to dropbox, drive or another and share the link.

 

Regards

 

Victor

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi valeriydik,

     

    I cannot understand how you arrived at the numbers in range C2:M13 of your Excel file.  They look like pasted special values.  Please share the underlying formulas.  Also, please explain the business logic of what you are trying to do.  What exactly is LGD?  What is the purpose of this exercise?

     

    Thank you.