Skip to Content (Press Enter)
UserImage.jpg
Audrius Taulavicius
209Views
1Comments
Decimal separator
Question
Hello, in input fields I need to show 4 or 2 decimal places and decimal separator should be comma, not dot as default in site paramet set. I changed decimal separator is site property to comma, but now when I do calculations and assigning results to fields I want to show, fields comes blank. I think there is problem, because when I do calculations, I am using FormatDecimal function, and when decimal separator is comma calculations did not work. What I should in my situation? 

Another problem I encountered is when I do custom SQL query and I have entity with two foreigns with same Entity
For example:
select
         {Account}.*
         ,{Dictionary}.*
         ,dict.*
from {Account}
        left join {Dictionary} on {Account}.[DictionaryId] = {Dictionary}.[Id]
        left join {Dictionary} as dict on {Account}.[AnotherDictionaryId] = dict.[Id]

And output structure looks like this:
Account
Dictionary
Dictionary_2

And problem I have is that ,dict.* did not work. What I have to do in situations when I need to join same table several times?


0
0
12 Aug 2015
Copy Link
2019-11-12 17-31-26
Justin James
 
MVP
Suggestion: use two separate posts for two separate questions.

1. FormatDecimal has always worked for me with commas. Please copy/paste your FormatDecimal expression.

2. Expand the "*" to all of the columns you are selecting.

J.Ja
0
0
13 Aug 2015
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.