I am having some difficulty programming one of my reports.
my current formula looks like this:
if {Properties.postal_code} startswith 'h4p' then 'West Island'
I need to have multiple starting codes what I have tried to do is this:
if {Properties.postal_code} startswith 'h4p' or 'h4m' then 'West Island'
But but it keeps telling me that a boolean is required here (shown in Red above).
Does anyone have an idea of how to get this done.
I basicly need to enter many startsWith values
Edited by blazeme182 - 22 Jul 2011 at 5:57am
IP Logged
