Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am working on following field which most values are like number but is in fact text. For those two highlighted, they contain a "D" and a "B", then the display is correct. For all others, they are still text. Even I use text(), it is still displayed as +14. This field is read from Excel file, is this the issue?
Finally, I worked it out. Thanks for your hint.
if(isnum(fieldname, Text(Num(fieldname,'0')), fieldname)
What happens when you try like
Text(Num(yourfieldname))
Hi,
num#(MyNum, '#','.',',')
num#(MyNum, '#,##0.00','.',',')
num#(MyNum, '#,#','.',',')
Those are not working.
Please note, some of this value contain letters, when I tried Num(), the letter's gone, and still like 1.3456788883344e+14.
And, when I extract from Excel and saved as qvd, this field shows correct format. After left join to my fact table as additional field, it shows wrongly.
Finally, I worked it out. Thanks for your hint.
if(isnum(fieldname, Text(Num(fieldname,'0')), fieldname)