Forum Discussion
Percentage value in negative = 0%
Hi all,
When our machine is tappering off to a stop and is in a certain timeframe, I receive a negative reject %. From my measure how do i make all negative % = 0% (zero)
Rejects % = DIVIDE([Rejects],[Inducted],0)
Thankyou in advance
Rejects % = IF( DIVIDE([Rejects],[Inducted],0) < 0, 0, DIVIDE([Rejects],[Inducted],0))
2 Replies
sevenhillsSuper User
Rejects % = IF( DIVIDE([Rejects],[Inducted],0) < 0, 0, DIVIDE([Rejects],[Inducted],0))