3 Replies Latest reply on Sep 18, 2018 5:06 PM by Shinichiro Murakami

# Calculated Field

HI all,

I have a question that I hope somebody can help with.

The attached file has 2 sheets--Actual and Plan YE. I'm trying to get the Growth calculated in the Actual sheet to be applied to the Plan YE sheet.

The problem is that the actual workbook has accounting period 2 selected and the plan has to have 12 selected.

Basically, the logic is that I'm taking the growth percent calculated in period 2 and then applying that growth to the year end plan (period 12)

The final formula should look something like this, which I saved as a calculated field "YE_Projection_Variance":

(1+[IA_Flash_Report (BRMReports)].[Growth])*SUM([Plan Amount])

The result should be 175,091*(1+8.25%)=189,536  I get 105,129....

I would appreciate any help.

• ###### 1. Re: Calculated Field

Hi ljubomir

Not exactly sure but you mean this?

175091 x (1+0.824536) = 189528

Thanks,

Shin

1 of 1 people found this helpful
• ###### 2. Re: Calculated Field

Thank you so much!

• ###### 3. Re: Calculated Field

Following up.