calculate

[DimaMD]

@HARIKRISHNA_T hi, Should your desired result be like this?
P02 = 130 - (60+60) = 10
P03 - 10- (30+60) = -50

[HARIKRISHNA_T]

Hi @DimaMD 

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 

[DimaMD]

@HARIKRISHNA_T Do your tables have dates?

[HARIKRISHNA_T]

Thanks @DimaMD for quick response

Here is the link for the table.

https://docs.google.com/spreadsheets/d/12TeSvdeEERgmgxl9rkeKaoe3xpeFVzvY/edit?usp=share_link&ouid=10... 

Regards,

Hari 

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[DimaMD]

@HARIKRISHNA_T Can you explain the calculation logic for P01?

[HARIKRISHNA_T]

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 

[HARIKRISHNA_T]

Hi @DimaMD 

any luck on this query.

regards,

Hari