Excluding zero amounts from separate columns in data tables

[#1]

I have an expression applied to a multibox to exclude Free bookings:

  =if(NETNET<>0,'Paid bookings','Free Bookings')

This works when only viewing data found in NetNet

We also have a variable on the report to exclude or include production charges and is associated to the script where if it has a value it is included, but if it is zero it is excluded

Is it possible the expression in the multibox can apply to both NetNet and Production Amounts ignoring the selections made to the variable?

I have tried:

=if((NETNET+PRODUCTION_AMOUNT)<>0,'Paid bookings','Free Bookings')

And the expression is ok, however when the production amount is zero it excludes the Net Net also.

any help would be appreciated

[cjohnson]

Hi Tez,

Can you put this field in the script? What happens if you put the following in the script:

LOAD

     *,

   if((NETNET+PRODUCTION_AMOUNT)<>0,'Paid bookings','Free Bookings')     as NewField

FROM

QVD;

You can then use this field in your multibox.

Thanks,

Camile