Hiding a column in a pivot table when the values are missing

[#1]

Hi,

How can I do to hide an expression in a pivot table if there is no value filled in?

I've tried by creating a variable vDisplayExpression = if(isnull(Expression), 0,1) and then putting in the Conditional of the expression vDisplayExpression = 1 but it doesn't work, it disappears even if there are values in cells.

Any help will be appreciated.

Thanks

[Anonymous]

Cristina

What is the expression ?

Best Regards,     Bill

[#3]

The expression is:

ACTUAL PRICES=(sum($(vAddedCost)) + sum($(vTotalPrice)))/Sum(TOTAL_QUANTITY)

where vAddedCost=GetFieldSelections(CR_COD_CURRENCY_SAP)&'_ADDED_COST (in our database we have the fields EUR_ADDED_COST, USD_ADDED_COST AND LOCAL_ADDED_COST, so, based on  user currency selection, one of those free fields will be used in analysis).

and

vTotalPrice=GetFieldSelections(CR_COD_CURRENCY_SAP)&'_TOTAL_PRICE (same for Total Price)

[fred_s]

Tried this one?

(sum($(vAddedCost)) + sum($(vTotalPrice)))/Sum(TOTAL_QUANTITY) <> 0