Quick Measure Incorrect Division

[walla386]

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!

[amitchandak · Accepted solution]

@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])

[walla386]

I feel quite silly for not catching that myself, thank you for the help!

[Fowmy]

@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 🙂

YouTube  LinkedIn