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
Yes I Load data from SAP, but not R3, I Use SAP BW.
Ufortunally, I can't use your approach because I don't Know how much zeroes are leading in each Material.
I have had great success with
evaluate(OriginalField & '* 1') as MyStrippedField;
Evaluate to force the field to be evaluated as a numeric the & '* 1' portion makes that evaluation against algebraic identity. if I need to also format a decimal point such as a string with leading zeros that also needs a decimal point placed as money
evaluate(OriginalField & '* .01') as MyStrippedField;
Or whatever the number of characters you need the field moved .1 .01 .001 etc.
Hope this helps.
WIT Inc Troy Michigan