Hi

I have a formula where if the first value is not met then look at the next if not that then the next etc....
if ({v.dmcode} = '001' and {v.CAD227} = 'on'  and {v.FullName} = 'Community') then 'O'
else
if ({v.CAD226} = 'on' and DateDiff('d', {v.ccadmit}, {v.STARTTIME}) < 31) then 'A'
else
if ({v.dmcode}='002' and ({v.CAD204} = 'on' or {v.CAD205} = 'on' or {v.CAD207} = 'on')) then 'T'
else
if ({v.dmcode} = '001' and {v.CAD227} = 'on'  and {v.FullName} = 'Clubhouse') then 'S'
else
if ({v.dmcode} = '001' and {v.CAD227} = 'on'  and {v.FullName} = 'Clubhouse & Community') then 'B'


it only seems to evaluate the first one?

Thanks
Joe