VARIENCE

[sagaraperera]

I want to new expression in variance but it is get the budget - actual how is create a expression

[awhitfield]

Hi Sagara,

you need to supply more information about your data.

Andy

[jonathandienst]

As an example:

In a table with Month (or date) as dimension, and these expressions:

     Col1: Sales = Sum(Sales)

     Col2: Budget = Sum(Budget)

     Variance: Column(2) - Column(1)

HTH

Jonathan