Need help on how to pull in previous month closing balance in Opening Balance Metric. Closing Balance refers to the Opening Balance. Basically Circular Ref, and just for ref need function similar to previous of Anaplan
Best answer by CDALMAY
View original
+5
Hi
To get rid of the circular reference, you use this article from
Basically, your Ending Balance formula will be :PREVIOUS(Month) + Movements_In + Movements_Out
Your Beginning Balance formula will be :
‘Ending Balance’[SELECT:Month-1]
Also, if you only intend to display the Beginning Balance in a table, you just need to create the Ending Balance metric and add it twice to the table :
Let me know if that makes sense
Thanks CDALMAY,
Solution worked, the Pigment Show as function also worked. The only condition that I will need to add is the first month opening balance to be picked from other table. Do you think we can do from Show as feature directly.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
