Decimal sign

Dynamics 365 Business Central/NAV User Group Developers Forum
#1

Hi,

is there any way to know in C/AL which decimal sign (. or ,) is used by the system?

#2

A possible solution.

IF system decimal sign is ‘,’ then this

should return >0 else it returns 0

#3

Very cunning! I’ll try it, thank you!

#4

Hey Nuno,

Really neat, great thinking.

Just tried it out.

I’m afraid You miss a 0 (zero) in the format-parameters.

STRPOS(FORMAT(1.1,**0,**1), ‘,’)

Works better.

#5

Or also this one (already using it for years):http://www.mibuso.com/forum/viewtopic.php?t=19429.

#6

Alain, just curious, if you wanted to reply, then why not reply here on Dynamics Users Net. Why all the rigmarole of posting on mibuso, and then posting a back link to the new post? Sounds like a very round about way of replying to a topic to me [;)]

#7

Actually, you don’t need any parameters. Just

STRPOS(FORMAT(1.1), ‘,’)

will do.

#8

True, but in I always move these topics to the Tips&Tricks forum, but in this case I have 2 problems :

  1. I don’t have moderator rights in forum “NAV - Developers Forum” :slight_smile:

and 2) Even if I had them, I wouldn’t know how to move the topic from dynamicsuser to mibuso.

And I have other Tips&Tricks but I should find some time to extract them and post them there, so I do that when an occasion comes up. And the fact that I am lazy makes me post it once and point to it in another post.