Forum Discussion
Solved
Round function in query editor
i have found a problem with ROUND function. what i was doing is as follows i have one price column, one quantity column in my table i am getting data from dynamics RMS where at the POS, custome...
In Query Editor, the Rounding is actually calling Number.Round() function. It has a third argument to sepcify round mode. In your scenario, you should use 0 or 2.
For more details, please see: https://msdn.microsoft.com/en-us/library/mt253380.aspx
In Query Editor, the Rounding is actually calling Number.Round() function. It has a third argument to sepcify round mode. In your scenario, you should use 0 or 2.
For more details, please see: https://msdn.microsoft.com/en-us/library/mt253380.aspx