I am using OLAP analysis services,

As part of the calculated members formula, I got a few cells with
negative numbers. And I would like to treat them as Zero or NULL if
the calculation turns out to be a negative number.

Is there a function I can do that??? IIF? or something else?

Please let me know as soon as possible!!
thanks
jon

the easy way:
create a new measure based on your table column and setup an SQL formula
like:
(SQL server syntax)
case when MyColumn <=0 then Null else MyColumn end

negative values become null values and these values are not aggregated by
analysis services.

"JJ SF" <datacentric (AT) gmail (DOT) com> wrote