0 Replies Latest reply: Sep 4, 2018 8:37 AM by sasikala Arunachalam RSS

    using if condition in pick and variable function

    sasikala Arunachalam

      Hi,

       

      I am facing a situation, where I need conditional values to be displayed as dimension.

      For example, My expression is like

      =PICK(vDashboard,if(([F1.autoCalendar.Date]>=YearStart(today(1),-1)),[F1.autoCalendar.YearMonth],''),if(([F2.autoCalendar.Date]>=YearStart(today(1),-1)),[F2.autoCalendar.YearMonth],''),if(([F3.autoCalendar.Date]>=YearStart(today(1),-1)),[F3.autoCalendar.YearMonth],''),if(([F4.autoCalendar.Date]>=YearStart(today(1),-1)),[F4.autoCalendar.YearMonth],''))

       

      Here, my requirement is , display

      yearMonth(F1) as dimension if date(F1) is greater than or equal to previous year's last date when vDashboard=1

      yearMonth(F2) as dimension if date(F2) is greater than or equal to previous year's last date when vDashboard=2

      yearMonth(F3) as dimension if date(F3) is greater than or equal to previous year's last date when vDashboard=3

      yearMonth(F4) as dimension if date(F4) is greater than or equal to previous year's last date when vDashboard=4

       

      My Problem is, dimension doesn't change when my vDashboard value changes.

      Is there a better way of replicating this requirment or is there any syntax issues. Please help!

       

      Regards,

      Sasikala