month i got the same results

[NavinReddy]

!Dear Experts,

Please help me below if condition i'm not getting exact Month selection filters

for all the months i'm getting exact same result, please suggest me where im doing wrong

   vMonth: =if(len(GetCurrentSelections()),max(MonthYear),MonthStart(Today()))

=if(Date($(vMonth),'MMM YY'),      if ((RAG_RATING_CD) = 'R', 'Tier1',

                                                  if ((RAG_RATING_CD) = 'A', 'Tier2',

                                                  if ((RAG_RATING_CD) = 'G', 'Tier3'))),

if(Date($(vMonth)-10,'MMM YY'),    if ((RAG_RATING_CD) = 'R', 'Tier1',

                                                    if ((RAG_RATING_CD) = 'A', 'Tier2',

                                                    if ((RAG_RATING_CD) = 'G', 'Tier3'))),

if(Date($(vMonth)-50,'MMM YY'),   if ((RAG_RATING_CD) = 'R', 'Tier1',

                                                  if ((RAG_RATING_CD) = 'A', 'Tier2',

                                                  if ((RAG_RATING_CD) = 'G', 'Tier3'))))))

Best Regards,

Niranjan

[t_chetirbok]

Hi!

please find attachment!

[NavinReddy]

Hi Digvijay,

i checked with 3 texboxes with the =Date($(vMonth),'MMM YY'),=Date($(vMonth)-10,'MMM YY'),Date($(vMonth)-50,'MMM YY') i got the three different months

when im using same in expression its not working for all the months im getting same result

please refer sample application attached

Best Regards,

Niranjan

[t_chetirbok]

I think it is what you need

[NavinReddy]

Hi Tatsiana,

please find the below image Sep'15 i have 7 Tier1's but i got the only one

Can you please check the expression based on month selection its not give exact values

Best Regards,

Niranjan

[NavinReddy]

Hi Tatsiana,

Exactly

[Digvijay_Singh]

May be because your expressions are missing left side of condition expression like =

if(Your date Date = (Date($(vMonth),'MMM YY'),

[Digvijay_Singh]

I don't have licensed version so cannot check the app.

[t_chetirbok · Accepted solution]

check app once again!

[NavinReddy]

Wow your rock Tatsiana,

exactly same i am looking for, Can you please tell me how you did this

Thanks a lot

Regards,

Niranjan