Solved: Format a number - Qlik Community

qvhjenvo · ‎2014-04-28

Hi,

I have a number for ex. 4,535910775293e-014

I want to format the number to for ex. 0,05. How?

Someone helps me!

Loi

MK_QSL · ‎2014-04-28

=NUM($(expUSDEksponeringTeller)/$(expBeløpNyePoliser)*POW(10,12),'#,##')

Update :

or

OR

=NUM($(expUSDEksponeringTeller)/$(expBeløpNyePoliser)*POW(10,RIGHT(SubField($(expUSDEksponeringTeller)/$(expBeløpNyePoliser),'e',2),2)-1),'#,##')

MK_QSL · ‎2014-04-28

NUM(YourNUMBERField,'#,##0.00') as YourNUMBERField

qvhjenvo · ‎2014-04-28

Hi,

I have tried this in a textbox

NUM('4,53591077529e-014','###0.00')

It does not work.

MK_QSL · ‎2014-04-28

Try in your script...

How is your field of NUMBER ?

its_anandrjs · ‎2014-04-28

Try to write like

=Round ( NUM(4,535910775293e-014,'#,##0.00'),1,0.05)

MK_QSL · ‎2014-04-28

Try

=NUM(SubField('453591077529e-014','e',1)*pow(10,LEFT(SUBFIELD(453591077529e-014,'e',2),1)&Right(453591077529e-014,2)),'#,##0.000')

rbecher · ‎2014-04-28

Do you mean 4,535910775293e-14? This would be a very small number..

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

rbecher · ‎2014-04-28

This shows a decimal value:

=Num(Num#('4.535910775293e-14'),'#,000000000000000',',','.')

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

maxgro · ‎2014-04-28

=

num(

subfield(upper(4.535910775293e-014),'E',1)

*

pow(10, subfield(upper(4.535910775293e-014),'E',2))

,'#,##0.000000000000000')

I added some 0 to format, your number is so small .....

qvhjenvo · ‎2014-04-28

Hi,

Want to post an attachment. So u can see better

But I can not see how to post the attachment.

Format a number