BusinessObjects Board

Help with Report Formula

building reports crystal reports
#1

Hello -

I have the formula listed below and there are 3 sections to it. Each section reports the correct number when individually on its own, but when all 3 sections are combined nothing works after the first section. I can move the sections around and still only the first section works. It’s like it doesn’t read the remainder of the lines.

How can I make these all work in 1 field? I put dashed lines in to represent each section, these are not in my code.

if {FullDW.F2626} = “Banked - Retail” and {FullDW.F1401} = “Renovation Con” then ((({FullDW.F2218}-100)/100*{FullDW.F2})+(({FullDW.NEWHUD_X794}+{FullDW.NEWHUD_X686})-{FullDW.CD2_XSTLC})+({FullDW.NEWHUD_X1151}+{FullDW.NEWHUD_X1152})-1975)-{FullDW.F454} else
if {FullDW.F2626} = “Banked - Retail” and {FullDW.F1401} = “Construction L” or {FullDW.F1401} = “Construction C” or {FullDW.F1401} = "Construction F"then ((({FullDW.F2218}-100)/100*{FullDW.F2})+(({FullDW.NEWHUD_X794}+{FullDW.NEWHUD_X686})-{FullDW.CD2_XSTLC})+({FullDW.NEWHUD_X1151}+{FullDW.NEWHUD_X1152})-2275)-{FullDW.F454} else
If {FullDW.F2626} = “Banked - Retail” and {FullDW.F1401} <> “Construction L” or {FullDW.F1401} <>“Construction C” or {FullDW.F1401} <> “Construction F” or {FullDW.F1401} <> “Renovation Con” then((({FullDW.F2218}-100)/100*{FullDW.F2})+(({FullDW.NEWHUD_X794}+{FullDW.NEWHUD_X686})-{FullDW.CD2_XSTLC})+({FullDW.NEWHUD_X1151}+{FullDW.NEWHUD_X1152})-1125)

if ({FullDW.F2626} = “Correspondent” and {FullDW.F1401} = “Renovation Con”) then (((({FullDW.F3714}-100){FullDW.F2})/100)+({FullDW.NEWHUD_X686}+{FullDW.NEWHUD_X794}-790)-((({FullDW.F2203}-100){FullDW.F2})/100)-{FullDW.NEWHUD_X1151}-{FullDW.NEWHUD_X1152}-850)- {FullDW.F454} else
if ({FullDW.F2626} = “Correspondent” and {FullDW.F1401} = “Construction C”) then (((({FullDW.F3714}-100){FullDW.F2})/100)+({FullDW.NEWHUD_X686}+{FullDW.NEWHUD_X794}-790)-((({FullDW.F2203}-100){FullDW.F2})/100)-{FullDW.NEWHUD_X1151}-{FullDW.NEWHUD_X1152}-1150) - {FullDW.F454} else
if ({FullDW.F2626} = “Correspondent” and {FullDW.F1401} <> “Construction C” or {FullDW.F1401} <> “Renovation Con”) then ((({FullDW.F3714}-100){FullDW.F2})/100)+({FullDW.NEWHUD_X686}+{FullDW.NEWHUD_X794}-790)-((({FullDW.F2203}-100){FullDW.F2})/100)-{FullDW.NEWHUD_X1151}-{FullDW.NEWHUD_X1152}

if {FullDW.F2626} = “Banked - Wholesale” and {FullDW.F1401} = “Renovation Con” then (((({FullDW.F3714}-100){FullDW.F2})/100)-((({FullDW.F2203}-100){FullDW.F2})/100)-{FullDW.CD2_XSTLC}-{FullDW.NEWHUD_X1151}-{FullDW.NEWHUD_X1152}-850) - {FullDW.F454} else
if {FullDW.F2626} = “Banked - Wholesale” and {FullDW.F1401} = “Construction F” then (((({FullDW.F3714}-100){FullDW.F2})/100)-((({FullDW.F2203}-100){FullDW.F2})/100)-{FullDW.CD2_XSTLC}-{FullDW.NEWHUD_X1151}-{FullDW.NEWHUD_X1152}-1150) - {FullDW.F454} else
if {FullDW.F2626} = “Banked - Wholesale” and {FullDW.F1401} <> “Construction F” or {FullDW.F1401} <> “Renovation Con” then ((({FullDW.F3714}-100){FullDW.F2})/100)-((({FullDW.F2203}-100){FullDW.F2})/100)-{FullDW.CD2_XSTLC}-{FullDW.NEWHUD_X1151}-{FullDW.NEWHUD_X1152}

Any help would be greatly appreciated!

CindiPratt (BOB member since 2018-12-13)

#2

I do not not what results you are expecting. But once you get a true in the if statement, the rest of the statement will not be processed.

kevlray :us: (BOB member since 2010-06-23)

#3

Try adding “else” to the end of the first 2 sections and see if that helps with your formula. That should allow it to continue to calculate all the different sections you have.

MikeVT (BOB member since 2019-02-07)