2 Replies Latest reply on Jun 15, 2016 2:37 AM by Morgan DUARTE

    Issue with formula with month as string

    Morgan DUARTE

      Hi there,

       

      I'm having a table with months set as 1, 2, 3 , ...12 (String)

      I'm trying to get the YTD value with the follow formula:

      IF [Month] <= [Month Selection] THEN [Sales]

       

      (Month selection being a parameter, set as String)

       

      However the system will includes 10, 11 and 12. (as it is still "inferior" to current monh, 6...)

       

      Any idea how to fix this?


      Thank you