Forum Discussion
Solved
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. ...
Please try the measure below:
% QRs Without NC = DIVIDE ( [Total QRs] - [NCs Found], [Total QRs] )
cengizhanarslan
Super User
Super UserPlease try the measure below:
% QRs Without NC =
DIVIDE (
[Total QRs] - [NCs Found],
[Total QRs]
)
Hi thank you, Managed to get it looking like the below, but cannot seem to get it as a %
- cengizhanarslan
Select the measure in the Fields pane
Measure tools → Format = Percentage
Set decimals