I have created a report which enables you to choose certain departments to view its income statement with the parameter {?Departments}. It allows you to choose more than one department in the select screen and it will shows both departments figures in one column. However I created a formula to show say' if {?department}='10' then 'ASTGY' if else blah blah' for the heading of the report but it doesn't like it if there is more than one department being selected.
I'm trying to change the formula to say if {?department} is 10
AND 11 then the heading will say 'ASTGY and Marines' as the string. Did try using 'if {?department} = '10' and '11' then 'ASTGY and Marines' but doesn't like it. Is this possible or should I change the actual parameter?
IP Logged
