Skip to main content

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! 

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

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

 

Thanks Limori. That did the trick in my formula!

Reply


Terms of UseCookie settings
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