Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, colleagues.I have a small problem, which I can't resolve elegant.
I want to remove leading zeroes from my Data.
I tried to do some text / num converting, but it didn't help me.
See attached file
'0000010 * 1' = 10
In my case I had both numeric and alphanumeric values in the same field.
Below worked for me..
if(Isnum(num(Num#(PROFIT_CTR))),text(num(Num#(PROFIT_CTR))),PROFIT_CTR)
Swapnil