Forum Discussion

Frequent Visitor

3 years ago

Solved

calculate

Ashish_Mathur
3 years ago
Hi,

You may download my PBI file from here.

Hope this helps.

Frequent Visitor

3 years ago

Greetings !

My Formula would for Opening Balance of current period = Closing Balance of previous period - Revenue(Current period) + Cash (Current Month).

I am looking for an formula to Calulate from Period 2 to Period 12.

Thanks in Advance.

regards,

Hari

Solution Sage

3 years ago

HARIKRISHNA_T Do your tables have dates?

HARIKRISHNA_T
Frequent Visitor
3 years ago
Thanks DimaMD for quick response

Here is the link for the table.

https://docs.google.com/spreadsheets/d/12TeSvdeEERgmgxl9rkeKaoe3xpeFVzvY/edit?usp=share_link&ouid=109019317121013628462&rtpof=true&sd=true

Regards,
Hari
- Ashish_Mathur
  Super User
  3 years ago
  Hi,
  
  You may download my PBI file from here.
  
  Hope this helps.
- DimaMD
  Solution Sage
  3 years ago
  HARIKRISHNA_T Can you explain the calculation logic for P01?
  - HARIKRISHNA_T
    Frequent Visitor
    3 years ago
    Hi DimaMD
    
    Till FY23 Period 1, we have actuals in Data. Now we have forecast data for REVENUE & CASH till FY23. However, We dont have Forecasted Unbilled balances from Fy23 P2-P12.
    
    Hence, Using Actuals Unbilled balance, wanted to calculate future Unbilled balances basing on Forecasted Cash And revenue.
    
    Regards,
    hari