hi i am here

[#1]

i have a category and am calculating mar and apr total sales month over month sale in mar and apr values tell me the expression

[Anonymous]

hey give some example your input and expected output.

Thanks

BKC

[#3]

Sum( {$<Date_Num={">$(=(MTDStartDate))<=$(=(MTDEndDate))"}>}  Amount))

MTDStartDate and MTDEndDate Variables

MTDStartDate==num(max(addmonths(Date,-1)))

MTDEndDate==num(Max(Date))

[#4]

Try like below,

=sum({<monthfield={'mar','apr'}>}sales)

[#5]

i am creating variable and vYear,vCurrentMonth,vPreviousMonth and i am pick for straight table dimention is Category

and expression is what ....i dont no

my expression is ---->  sum({<year={$(vCurrentMonth)}>}sales)

                         -----> sum({<year={$(vPreviousMonth)}>}sales) this expression is right or wrong it's wrong tell me this answer

[Anonymous]

your expression syntax is correct.

But you want to sum of both the month sale (current + previous)

So you need to write -

sum({<year={$(vCurrentMonth)}>}sales) + sum({<year={$(vPreviousMonth)}>}sales)

Current month sale =10

Prev month sale = 20

then you will get 30

Thanks

BKC