Skip to Content
Former Member
Mar 31, 2011 at 07:41 AM

Formula Order



I'm using 2 formulas below;

{Interaction.Date_Created} in YearToDate and

{Interaction.Call_Sub_Type} = "FC539 Letter Details" and

{Employee_1.Full_Name} = "Joe Bloggs" and

isnull({Interaction.Closure_Code}) or

{Interaction.Date_Created} in YearToDate and

{Interaction.Closure_Code} in ["Returned to CC to Investigate", "Feedback Only"] and

{Employee_1.Full_Name} = "Joe Bloggs"

As you can see I'm using 'or' but when I swap the 2 formulas round the report pulls back different results. Is there any reason why the order 2 formulas are put in to the formula expert make a difference?

Many thanks,

Alex O