Skip to main content
Solved

Changing ?ERROR to value 0

Platinum Innovator
Forum|alt.badge.img+3

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! 

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

View original
This topic has been closed for replies.

3 replies

Limori
Planview Falcons
Forum|alt.badge.img+4
  • Limori
  • Planview Falcons
  • Answer
  • April 14, 2024

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

Limor Schmitz
    Platinum Innovator
    Forum|alt.badge.img+3

    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

     

      Platinum Innovator
      Forum|alt.badge.img+3

      Thanks Limori. That did the trick in my formula!

        Terms of UseAccessibility statement
        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