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 ????
Go to Solution.
@Bigrover yes it will, then you have to add a measure
% Approved =
DIVIDE( SUM( Table[Approved] ), SUM( Table[Received] ) )
Proud to be a Datanaut! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
View solution in original post
@Bigrover 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).
@Bigrover 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?
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!