Number Format.

[Architect]

HI,

I just encountered one problem here. For an expression

While using '# ##0,0%' as number format , result is 74,8%

but making it '# ##0.0%' and result becomes 74.0%. can someone please explain why.

Below is the full expression:-

if(match(getcurrentfield(Range_Structure),'RU','Purchasing Area (POA)','Purchasing Team','Supplier','Purchasing Group','Range Status')=0,

(num(Count({<[Range Status]=,SnapNo={1}, HAVE_ASSESMENT={1},[Item Status]={Sellable}>}DISTINCT [Item No])
/
Count({<[Range Status]=,SnapNo={1}, HAVE_ASSESMENT=,[Item Status]={Sellable}>}DISTINCT [Item No])
,'# ##0,0%')),'')

[Vegar · Accepted solution]

It depends on our variable 

SET DecimalSep=',';

If you wan't to present the value with an '.' as decimal you can do like this (using hte third parameter in num():

=num(Expression1 ,'# ##0.0%', '.')