Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago
Solved

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

Originally posted by Chris Bielinski

4/20/2020

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

  • 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

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    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)