What is the Best way to calculate percentage

ERP Epicor ERP 10
1

Im trying to calculate the percentage of True values by sync date so for this day there are 800 records and i need to know the percentage of True values of the Shortage field.
whats the best way to do this?

image
image1040×745 27.3 KB

2

One possible way to accomplish this could be to:

  1. Add a transform if-then column to designate True = 1 and False = 0 as [short_count]
  2. Add another transform column with simply ‘1’ as [line_count]
  3. Add both columns to the Measures.
  4. Create a Custom Measure to divide the two values and multiply by 100:
    ([short_count / [line_count]) * 100
  5. Change the new measure’s format to a percentage.
2 Likes
3

Thank you, that worked.