Forum Discussion
Issue with reversing a percentage
Hi BarneyR
From your figure 2 ,I think the result you want for Missing Data is the sum of three percentages, 'Table'[Output%] , 'Table'[Downtime%] , 'Table'[Reject%]
Calculated column
Missing Data = IF('Table'[Output%]+'Table'[Downtime%]+'Table'[Reject%]<1,'Table'[Output%]+'Table'[Downtime%]+'Table'[Reject%],0)
If the sum of 3 percentages <1,the return value is 0 .Otherwise ,it will return the sum of 3 percentages .
The effect is as shown:
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Most Valuable ProfessionalHello BarneyR ,
you said it's a calculated column with the following formula:
Missing Data = IF([total_percentage] < 1, 1 -[total_percentage],0)
This means the rows for hours 10-13 have either "1-[total_percentag]" or a 0 as a value.
So they must have values.
Can you post a screenshot with the calculated column for the hours 10-13 or share the file? This would make it easier.
Hello selimovd
Unfortunately it is not letting me give a proper reply as it is complaining about HTML being incorrect but I am not even using the HTML editor, nor is it showing me what HTML is actually incorrect.
There is no data for this record for hours 10-13. There is data in this table that do have hours 10-13, but they are for a completely different record.
It seems like it is showing me data regardless of it being the selected parent_id (which is the column that groups the relevant rows together).
I have a relationship to pa_header on pa_header.id = pa_output.parent_id.
What's odd is that if I remove the calculation that works out the remaining percentage out of 100, the correct number of rows show (9). It's when I minus 1 from the percentage (to get the remainder) when it messes up.