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 30 ????
Formula?
Anonymous yes it will, then you have to add a measure
% Approved = DIVIDE( SUM( Table[Approved] ), SUM( Table[Received] ) )
5 Replies
Anonymous is it approved divided by received, add following column and change it to %
% Approved = DIVIDE( Table[Approve], Table[Received])
Anonymous doesnt make sense, it should return 0.6 and when you change format to % it would show 60%