Hello community,
I’m wondering if anyone has figured out how to change any values that come up as ?ERROR to a 0 value instead for field calculations within a report? Much appreciated!
Solved
Changing ?ERROR to value 0
Best answer by Limori
Hi Kayla
I assume you were using a formula field that ended up showing you the ?ERROR?
In this case I suggest to use an IF statement in the formula, that addresses the scenario in which you would run a division by 0, e.g.:
If(IsEmptyOrZero($xyz),0,$abc/$xyz)
I hope that helps.
Limor
+4Hi Kayla
I assume you were using a formula field that ended up showing you the ?ERROR?
In this case I suggest to use an IF statement in the formula, that addresses the scenario in which you would run a division by 0, e.g.:
If(IsEmptyOrZero($xyz),0,$abc/$xyz)
I hope that helps.
Limor
Hello, Limori. Thanks so much for your response. How you recommend I incorporate it into my existing formula:
($CapacityOfUserDaily.LoadFor.LinkObject.ActualApprovedBillable/($CapacityOfUserDaily.Capacity*0.8))*100
Reply
Most helpful members this week
Planview Customer Community
Already have an account? Login
Planview Customer Community
No account yet? Create an account
Login with SSO
Login with Planview Adminor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
All Data Subject Access Requests (DSARs), and requests of “Do Not Sell My Personal Information” according to the CCPA, must be submitted through the Planview DSAR portal located here
Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com
Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com