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?
  • OSAdmin's avatar
    OSAdmin
    6 years ago
    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)

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