How to Hide Decimal when decimal was zero or 0, show when decimal higher than 0 ?

[RickyJ]

Hi mate, 

does anyone can help me how to get rid or hide decimal if it zero ?

only show if the number was above 0.

on image that i post, i have Qty Column, can i hide the .0 number ?

show only if the number was eg. 7.5 or 10.9 ?

[Aurelien · Accepted solution]

I'm not aware of a formatting that allows to do so.

You may want to add a new virtual column that will display the [YourDecimal] or NUMBER([YourDecimal]), such as this:

IF(MOD([yourDecimal],1)>0,
  [yourDecimal],
  NUMBER([yourDecimal])
)

Please note such column should be with type Text.

[Aurelien]

Hi @RickyJ 

You may want to apply a Show_If condition to your column.

I suggest:

[_THIS]<>0.0

[RickyJ]

My view was different, i mean if there is no decimal, just show the number without point decimal.

eg: If number qty was 8.0 only show 8. if 6.2 show 6.2.

If - Show

6.0 - 6

10.0 - 10

11.5 - 11.5

6.2 - 6.2

8.0 - 8

[Aurelien · Accepted solution]

I'm not aware of a formatting that allows to do so.

You may want to add a new virtual column that will display the [YourDecimal] or NUMBER([YourDecimal]), such as this:

IF(MOD([yourDecimal],1)>0,
  [yourDecimal],
  NUMBER([yourDecimal])
)

Please note such column should be with type Text.

[RickyJ · Accepted solution]

Thanks Aurelien for your help.

it help me for my case but it need a little modification.

Change Number([yourDecimal]) With Decimal([yourDecimal])

And i use text virtual column.

Eg :

IF(MOD([Qty],1)>0,
  [Qty],
  Decimal([Qty])
)