Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you want the result to be fixed length (three digits), you can use formating:
num(<whatever>, '000')
Regards,
Michael
Hi,
try with the function Concat()
LET vFisPd = if(len('$(vFisPd)' - 1) < 2, Concat('00'& '$(vFisPd)' - 1),Concat('0'& '$(vFisPd)' - 1)
Rebeca
If you want the result to be fixed length (three digits), you can use formating:
num(<whatever>, '000')
Regards,
Michael