Forum Discussion
TimBriggs
9 months agoNew Member
Table Column to Calculate Totals
Hi all, I want to add a column to the table below which show the % of Total QR's done without an NC found? So in this example, 3 total QRs complete. 1 NC found would be 66.66% correct. ...
- 9 months ago
Please try the measure below:
% QRs Without NC = DIVIDE ( [Total QRs] - [NCs Found], [Total QRs] )
cengizhanarslan
Super User
9 months agoPlease try the measure below:
% QRs Without NC =
DIVIDE (
[Total QRs] - [NCs Found],
[Total QRs]
)- TimBriggs9 months agoNew Member
Hi thank you, Managed to get it looking like the below, but cannot seem to get it as a %
- cengizhanarslan9 months ago
Super User
Select the measure in the Fields pane
Measure tools → Format = Percentage
Set decimals