cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## calculate

1 ACCEPTED SOLUTION
Super User

Hi,

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
8 REPLIES 8
Solution Sage

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

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com
Frequent Visitor

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.

regards,

Hari

Solution Sage

@HARIKRISHNA_T Do your tables have dates?

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com
Frequent Visitor

Thanks @DimaMD for quick response

Here is the link for the table.

Regards,

Hari

Super User

Hi,

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Solution Sage

@HARIKRISHNA_T Can you explain the calculation logic for P01?

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com
Frequent Visitor

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

Frequent Visitor

Hi @DimaMD

any luck on this query.

regards,

Hari