4 Replies Latest reply: Oct 9, 2017 9:31 AM by Stefan Wühl RSS

    Convert if statement to pick - match function

    Mohammad Adnan Ansari

      How to convert the below if statement to pick - match combination:

       

      If(getselectedcount([Year])<1 and getselectedcount([Month Year])<1

      ,

      Sum({$<[Month Year]=,[Year]=,[MonthID]= {"$(=((Year(Today()) -1)*12) + Num(Month(Today())))"}>} [Target])

      ,

      Sum([Target])

      )