Rank: Member
Groups: Registered
Joined: 4/17/2015(UTC) Posts: 17  Thanks: 1 times
|
Dear Support,
When defining the numerical format as N0, average values are always rounded down. i tried changing it to custom format and set it to 00 or ##, but the values still rounded down.
Is there a way to make it behave differently (round up or down based on value)?
Regards,
Jean-Yves
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
The "00" specifier causes the value to be rounded to the nearest digit preceding the decimal, where rounding away from zero is always used. For example, formatting 34.5 with "00" would result in the value 35. You can check the MSDN documentation: I made a try and it works 212.64 is rounded to 213...
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 4/17/2015(UTC) Posts: 17 Thanks: 1 times
|
I did try 00 and it still gave me the rounding down.
Just to make sure I understood you correctly, I pick the value I am averaging on, specify custom format and put the value 00 in the Custom Format field, right?
Jean-Yves
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
yes, in my model, I select the element in the Data element, then:
Format: Custom
Custom Format: 00
Perhaps it depends on you computer localization settings...
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 4/17/2015(UTC) Posts: 17 Thanks: 1 times
|
It didn't work :(
Is it something that was solved in version 2.0? Because I am using version 1.8.
Thanks
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
No I am sorry, it has nothing to do with the version...
I am surprised that it does not work as it is standard .Net formatting. Check if the issue is not somewhere else.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
