IF with current month condition

[#1]

Hi, guys!

I have a table as follow:

Months	Jan	Feb	Mar	Apr	May	Jun
BG_bench	Bench USD	Bench USD	Bench USD	Bench USD	Bench USD	Bench USD
Engineering	0	0	0	0	0	0
Genesys	-	-	-	-	-	-
International other	-	-	-	-	-	-
Kyivstar	-	-	-	-	-	-
Lindorff	-	-	-	-	-	-
Telecom	-	-	-	-	-	-
Ukraine other	-	-	-	-	-	-
0	-	-	-	-	-	-
Total	0	0	0	0	0	0

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?

[PrashantSangle · Accepted solution]

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