Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%')),'')
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%', '.')
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%', '.')