IF with current month condition

Fri, 03 Apr 2015 07:20:33 GMT

Hi, guys!

I have a table as follow:

I need to write th expression with the condition that if the month is older than the current month I need to calculate with distinct formula.

Like I have an expression now:

If( Month_name<$(vCurMonth),0,Sum({$<Year={2015}>}Sal*Bench_Data))

vCurMonth= monthname(today())

But this formula isn't working properly.

Any ideas?

Re: IF with current month condition

PrashantSangle — Fri, 03 Apr 2015 07:30:16 GMT

Hi,

In set analysis add Month_name<$(vCurMonth) condition

try like

If( Month_name<$(vCurMonth),0,Sum({$<Month_name={"<$(=monthname(today()))"},Year={2015}>}Sal*Bench_Data))

Regards