how should calculate variance between dynamic input?

[#1]

HI  Experts,

how should calculate Actual cost varience  between two month.

[Former Member]

Can you use something as simple as Previous?

=[Actual Cost] - Previous([Actual Cost])

[Former Member]

Hi

From the screen shot it says only u r using 2 months here.

But if you are running for year,then this can be the steps.

1.sort month ..go to values and the arrange .

2.The data should display properly monthly wise

3.Then If you have direct month object then create Previous([Month]).we have previous function

4.write Diff=[Actual Cost]-Previous Actual Cost

[Former Member]

and one more point you have to remember is for JAN 2014(If you are running for Current yr) then You have to include IF[Month]=JAN then [Actual cost ]else Diff=[Actual Cost]-Previous Actual Cost

[Former Member]

Prev_Month_Actual_Cost = [Actual Cost] where ([Month] = previous([Month])) //Before using previous function make sure that all months are in sorted order.

Two_Months_Cost_Diff = [Actual Cost] - [Prev_Month_Actual_Cost]

[Former Member]

From the snapshot, it seems you getting [Month] as a single object and [Actual Cost] as another object

Would you be getting 2 months data always?

as you need to split the 2 months cost to get the difference

=[Actual Cost] Where ([Month] = [Month 1] ) - [Actual Cost] Where ([Month] =[Month 2])

Is there a way you can identify the 2 months which needs to be considered?