5 Replies Latest reply: Jul 3, 2017 4:23 AM by Sada Siva RSS

    Concatenate Year and Month whitin a Function

    Luis Carmona Martínez

      Hi,

       

      I have a Variable call that has $1 related to the a Yearmonth variable.

       

      The Followin formula is producing the expected result, so it´s OK.

       

      $(vKPI_CLI_PED($(=text($(vAnyoPedIso)*100 +1))))

       

      vKPI_CLI_PED: This is my variable, that has not problems at all.


      The $(1) of the vKPI_CLI_PEDis then replaced for ($(=text($(vAnyoPedIso)*100 +1)))


      vAnyoPedIso result is 2017 (year), That when is multiplied by 100 and plus 1 will endup being 201701 (201700+1)


      I need now to produce something different for this Time formula.


      Concatenate text($(vAnyoPedIso) with OnlyNumberMonth.


      • vOnlynumberMonth is a dimension has the following values for 12 months: 01, 02, 03, 04....12 


      But I am not able to produce the right result with CONCATENATE, please any help??


      I was trying something like:


      $(vKPI_CLI_PED($(=Concat(text($(vAnyoPedIso),OnlyNumberMonth ))))


      But is not working.