Print Page | Close Window

?? on evaluate all values in a formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19691
Printed Date: 02 May 2025 at 10:13am


Topic: ?? on evaluate all values in a formula
Posted By: jbalbo
Subject: ?? on evaluate all values in a formula
Date Posted: 20 Jun 2013 at 10:41am
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


Replies:
Posted By: DBlank
Date Posted: 20 Jun 2013 at 10:49am

do you have NULL values in your data set?

Change the option inthe formula editor to 'use default values for nulls'


Print Page | Close Window