Forum Discussion
Helper IQuick Measure Incorrect Division
Hello,
I've seen that this is a relatively common issue but I was having trouble translating other's solutions to my scenario. Each day has different amounts of blocked stock, clear stock and total stock quantity so I used the WEEKNUM function to help totalize these values for each week. Problem is when I used a quick measure for First Pass Quality (= Clear Stock/Total Stock) I get 100% instead of 99.72%.
Thanks in advance for the help!
walla386 , Check the data type and number of decimal places under the column/measure tool.
Also better to use divide([Clear Stock],[Total Stock])
or
divide([Clear Stock]*1.0,[Total Stock])
3 Replies
- Fowmy
Super User
walla386
Can you share the real formula?Have you applied the correct formatting to the measure? with Percentage with 2 decimals?
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
- amitchandak
walla386 , Check the data type and number of decimal places under the column/measure tool.
Also better to use divide([Clear Stock],[Total Stock])
or
divide([Clear Stock]*1.0,[Total Stock])
walla386I feel quite silly for not catching that myself, thank you for the help!
