Forum Discussion
Solved
Reverse Percentage
Hi, I would like to reverse this percentage view. To be 100% - 1.62% = 98.38% If I then add in 1- at the front it, it then messes with the time analysis. ...
Toots , Try
divide([Count Order Lines]-[Cancelled Order Lines],[Count Order Lines])
or
if([Cancelled order line]<>0, divide([count of order line]-[Cancelled order line],[count of order line]),blank())
Toots , Try
divide([Count Order Lines]-[Cancelled Order Lines],[Count Order Lines])
or
if([Cancelled order line]<>0, divide([count of order line]-[Cancelled order line],[count of order line]),blank())
divide([Count Order Lines]-[Cancelled Order Lines],[Count Order Lines])
Legend! This works perfectly. Thank you