Number formatting

[#1]

I have expression like below,

If(GetFieldSelections(Measure)='SQF',

num((Sum({$<[Type] = {'Used'} >}[SF])),'#,##Sf'),

num((Sum({$<[Type] = {'Used'} >}[SF]*(0.9203))),'#,##Sqm'))

Now,when I set the number to expression default I am getting value something like 1.15E+0.007 and if I set the number to fixed to 0 decimals I dont get Sf or Sqm in front of the number.

Any suggestion/help is much appreciated.

[Rajamohan]

Try to use & to concatenate symbol with numbers.

- Mohan

[engishfaque]

Dear Pavana,

Kindly find attached file, I hope you are looking for that one solution.

Kind regards,

Ishfaque Ahmed

[PrashantSangle]

Hi,

Try

If(GetFieldSelections(Measure)='SQF',

num((Sum({$<[Type] = {'Used'} >}[SF])),'#,00 Sf'),

num((Sum({$<[Type] = {'Used'} >}[SF]*(0.9203))),'#,00 Sqm'))

or

Try

If(GetFieldSelections(Measure)='SQF',

num(Floor(Sum({$<[Type] = {'Used'} >}[SF])),'#,00 Sf'),

num(Floor(Sum({$<[Type] = {'Used'} >}[SF]*(0.9203))),'#,00 Sqm'))

You can use Floor, Round, Ceil function as per requirement

If you want Sf or Sqm in front of the number.

then

If(GetFieldSelections(Measure)='SQF',

num((Sum({$<[Type] = {'Used'} >}[SF])),'Sf #,00'),

num((Sum({$<[Type] = {'Used'} >}[SF]*(0.9203))),'Sqm #,00'))

Note : GetFieldSelections() work when you select field value in Measure.

Regards,

[HirisH_V7]

Hi,

You can use expression like this,

=Num(Sum(Value), '#,##0.00 Sqm')

&

=Num(Sum(Value), '#,##0.00 Sf')

Is your Value format is in exponential??

Then in edit script,

Num(YourValue, '(dec)') as Value 

HTH,

Hirish