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

[OSAdmin]

Originally posted by Chris Bielinski

4/20/2020

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

[OSAdmin · Accepted solution]

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)