If statement for Month selection

[Karim_Khan]

Hi Team,

    I wanted to use If statement for Month selection  in expression.

Currently My calculation is working as below

=sum({$<FiscalMonth=>}[Net Bookings])

and expression

=AGGR(IF(Rank(sum([Net Bookings]), 4)<=5, [End Customer Global Ultimate Name]),[End Customer Global Ultimate Name])

When I click on Month then values gets associated from Fiscal Month

Month,Fiscal Month

Oct,3

Nov,4

Feb,7

Mar,8

But I want to Apply if condition so that If I will select the Month May then it should pick up the 3

May,3

Jun,4 and so on.

I want this dynamically.

Pls help me out

Regards,

KK

[Karim_Khan]

8

[sasiparupudi1]

=num(month(date(addmonths(num(Month(Date)) ,- 2),'MMM')))

[Karim_Khan]

Sir value is not getting changed while selecting the month.

Its got fixed to one specific number.

like 11

[sasiparupudi1]

please try

num(month(date(addmonths(date#(Date,'MMM'),-2),'MMM')))

[Karim_Khan]

I am trying to put the Fiscal Month but it is not getting calculated

=num(month(date(addmonths(date#(FiscalMonth,'MMM'),-2),'MMM')))

[sasiparupudi1]

hi

sorry I am not following what you want to try here.

the expression num(month(date(addmonths(date#(Date,'MMM'),-2),'MMM')))

should give you fiscalmonth for a selected date in the number format 1,2,3, 4 etc..

if you want to subtract 2 month from the fiscal month then the following should work

=num(month(date(addmonths(date#(FiscalMonth,'MM'),-2),'MMM')))

hth

Sasi