Nested If statement not working

[#1]

I need to display a stacked bar chart with  2015, 2016 , 2016-Q3, 2016-Q4 and 2016 - Jul  as X axis, whereas Jul is in the third quarter as per the calendar.

=if(FY_12='2015',FY_12,(if (FY_12='2016' and Quarter_12='3',FY_12&'-Q'&Quarter_12,(if (FY_12='2016' and Quarter_12='4',FY_12&'-Q'&Quarter_12,(if(FY_12='2016' and Month_12='Jul',

FY_12 & '-'& Month_12,(if (FY_12='2016',FY_12,)) ))

)))  ))

As per the above if condition, the charts are not displaying values for 2016-Jul. Could someone help me in tweaking this if condition?

[tamilarasu]

Hi Arunkumar,

Try this,

=if(FY_12='2015',FY_12,

     if(FY_12='2016' and Match(Quarter_12,'3','4'),FY_12&'-Q'&Quarter_12,

       if(FY_12='2016' and Month_12='Jul',FY_12 & '-'& Month_12,

           if(FY_12='2016',FY_12

              )

          )

       )

     )

If it's not working, I would suggest to post a sample application.

[shraddha_g]

Also you can try

if( wildmatch(FY_12,'2015','2016') , FY_12,

       if(wildmatch(FY_12,'2016')  and wildmatch( Quarter_12,'3','4'), FY_12&'-Q'&Quarter_12,

                        if(wildmatch(FY_12,'2016')  and wildmatch( Month_12,'Jul') ,FY_12 & '-'& Month_12

                           )))

[sasiparupudi1]

If you are using this as a calculated dimension, you need to add the same logic in your expressions otherwise it is not going to show the results.

Please post a sample