Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to use a dynamic numberformat, ie. use a format stored in a field to format another field.
For example, if I have tha data below, could I somehow use the expression =num( [Value] , '[numberformat]' );
LOAD * INLINE [
Value, NumberFormat
"0,7511", "#0,00%"
"0,5012", "#0,0"
];
TIA
//Ola
Hello
num(Value,NumberFormat)
Thanks, but that example does not use the actual value from a field as the numberformat.
I am looking for a way to pick the fieldvalue of [NumberFormat] and use it as the formatting parameter in the num function.
//Ola
Thank you, it works!
I actually tried num(Value,'NumberFormat') and it did'nt work but now I understand that those pesky quotes are'nt needed!
Thank you!
//Ola