Calculations: I'd like NO Decimals

[ecca64]

Hi

How can I get no decimal in a calculation field: picking No Style in Number Format only gives me a 6 digits decimal

Thanks

Eric

[Brendan]

Hello Eric,

No Style simply applies no number formatting style to the field. So if there are decimals in the value, it will display them. But will also not display thousands separators either.

There’s no option at the moment to specify the number of decimal points. But this is something I should really add to the number formatter options screen to a future update.

Thanks,

Brendan

[DrJJWMac]

Could you also please do this by allowing standard formating codes?

%3.2f <– floating with three sig figs, two to right of decimal

%g <– general

http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx

—

JJW

[Brendan]

Hi JJW,

Hmm… Well, that’s not very friendly for novice users. I would probably add something in a little more user friendly than that.

Thanks,

Brendan

[DrJJWMac]

Yes .. those unfamilar with such programming codes could be confused. But then, for those in the know, this path is far less cluttered than having to sort through buttons and popups and other selection icons on a screen to set the various options available by the codes themselves. Perhaps this could be provided as a special Advanced option.

—

JJW

[Marisette]

I got my calculated field to display no decimal points by selecting the number format “Decimal Style”, oddly enough. In case you need it NOW

[Author]

Posts