Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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