Expression problem...!!!

[#1]

Dear All,

My basic expression is as follows.

ROUND(RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM))

The above formula was modified as follows to show only the negative values in the pivot table.

ROUND(ONLY({<RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM))={<"0"}>}RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM))

But the formula has a error in itself. Please help to find the correct formula(expression)

Regards,

Priyantha.

[#2]

Try this

i have added field (columnname) and created a variable (RANGESUM=RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)=0)

ROUND(ONLY({<FIELD={"$(RANGESUM)"}>}RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)))

check if it helps

[#3]

Dear Pooja,

Even your expression shows as "expression ok"  , expected result not achieved,

Regards,

Priyantha.

[maxgro]

maybe

if (

     RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM) <0,

     RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)

     )

[#5]

Dear Priyantha,

if possible could you provide some sample data and expect result

[MarcoWedel]

RangeMin(ROUND(RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)),0)

and maybe check "suppress zero values" in your chart.

hope this helps

regards

Marco

[#7]

Try with this

if (

     RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM) <0,

     RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)

     )