Even if I don't use the mask, and explicitly put in the percentage format, its still doesn't work.
This is the expression in my script that doesn't work:
If(Upper(Trim(FORMAT))='PCT', Num(Num#(VALUE, '0.00%'),'0.00%'),
If(Upper(Trim(FORMAT))='DOUBLE',Num(Num#(VALUE, MASK), MASK),VALUE)) as VALUE_FORMAT2
I didn't use the 0% mask that was loaded from excel. I put in the actual percentage format, but it doesn't work.