2 Replies Latest reply: Jun 19, 2013 10:45 AM by Michael Solomovich RSS

    Fiscal Period (5 not 005)

    Thom Mumaw

      Group need alittle help.  Take a look at the statement  below:

       

      LET vFisPd = if(len('$(vFisPd)' - 1) < 2, '00', '0') & '$(vFisPd)' - 1; 

       

      vFisPd is equal to 006, but my final outcome is 5 and should be 005. Any ideas?

       

      Thanks