Help in Expression

[#1]

Hi,

I have a line chart with one dimension and multiple expressions.

Dimension is Months

For some of the expressions, i have to calculate expression values as PREVIOUS MONTHS' VALUE - CURRENT MONTHS' VALUE

Is it possible to implement the same?

[ali_hijazi]

if 4 (April) is your current month (selected) then previous month would be as follows:

create a variable and name it vPreviousMonths

in the definition put

=max(Month) -1

then in your expression if it is sum(sales)

it would be sum(sales) - sum({<Month={$(vPreviousMonth)}>}Sales)

Hope this helps

[ashfaq_haseeb]

Hi,

Check this

Comparing Current Month and Previous Month Sales

Regards

ASHFAQ

[ariel_klien]

Hi,

You can try the command 'above'

something like above(sum(value))-sum(value) when the dimension is month.

BR

Ariel

[#5]

I have to write an expression such as

when YearField=2013, (100-(Prev Value-Curr Value)/Prev Value)*100 as Expr1

and for all other years it should be previous value of Expr1 -((Prev Value- Curr Value) /Prev Value) * 100 as Expr1

[mdmukramali]

Dear,

can you attach the sample file so that we can help you in a better way.

Thanks,

Mukram