Forum Discussion
Percent Column
I am trying to find percent approved, and having trouble. This is in a table by month and year Year Month #Received # Approved %Approved 2019 Feb 50 ...
Anonymous yes it will, then you have to add a measure
% Approved = DIVIDE( SUM( Table[Approved] ), SUM( Table[Received] ) )
Anonymous is it approved divided by received, add following column and change it to %
% Approved = DIVIDE( Table[Approve], Table[Received])
That doesn't work - it pulls a percent in the thousands, when it should be around 50% (for the real data).
Anonymous doesnt make sense, it should return 0.6 and when you change format to % it would show 60%
the months are summed data. Receieved is a sum of many entries as well as approved. Does this make a difference?