Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 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
    Icon for OneStream Employee rankOneStream Employee
    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)