Skip to main content
O
OSAdmin
June 29, 2020
Solved

Is there any way to filter out 0's when using cube math?

  • June 29, 2020
  • 1 reply
  • 0 views
Originally posted by Chris Bielinski

4/20/2020

Is there any way to filter out 0's when using cube math?

    Best answer by OSAdmin
    Originally posted by Cosimo Palmisano

    Use Divide in the GetDataCell. I think Divide checks the numerator and denominator prior to dividing.

    GetDataCell(Divide((CVC(OP1_NY) - CVC(OP1)), CVC(OP1)) * 100)

    1 reply

    O
    OSAdminAuthorAnswer
    July 14, 2020
    Originally posted by Cosimo Palmisano

    Use Divide in the GetDataCell. I think Divide checks the numerator and denominator prior to dividing.

    GetDataCell(Divide((CVC(OP1_NY) - CVC(OP1)), CVC(OP1)) * 100)

    Terms & ConditionsAccessibility statement