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