Number Formatting

[#1]

hi

i have a number in with say 9 digits...100000000 which is essentially 100million...how do i format this number to show £100.0m without having to divide by 1000000/

thanks

Jason Lee

[hic]

You could for example use the dual function: first parameter is how it should look and the second is the numeric value it should have:

dual('£ ' & round(Number/1000000,0.1) & 'm',Number) as Number

/HIC

[#3]

1)  In the Properties> number> Format Pattern settings you can select money and in the format pattern make the respective changes. In the number format settings, if you like to see for thousands symbol and what you like to see for millions symbol and in the format pattern change to £.

else

Num(field/1000000,'£ #.0 m')

[#4]

My answer was for the interface.

[#5]

thanks for this...i was wondering if this could be done without me having to divide the original number by 1000000.

[#6]

This feature was working perfectly in QlikView 8.5: