Nested Formula Issue 1

[briesen]

I have a fairly simple nested formula, but I'm struggling to get the correct format. I know that the formula at the end is redundant, but I was just trying to figure out how to get it to work.

Round
(if isnull({tei.dteFileCreated}) then
if {vtr.Mode}="LTL" 
then ({vtr.TotalARAmt}-{vtr.curARAddedFee})*1.37+{vtr.curARAddedFee} 
else 
if {vtr.Mode}<>"TL" 
THEN ({vtr.TotalARAmt}-{vtr.curARAddedFee})*1.1+{vtr.curARAddedFee}) 
ELSE 
IF {vtr.Mode}="TL" 
THEN ({vtr.TotalARAmt}-{vtr.curARAddedFee})*1.23+{vtr.curARAddedFee})
else if NOT isnull ({tei.dteFileCreated}) then {tei.curARAmtwMarkup}+{tei.curFee},2)

 

[fisheromacse]

there may be other things, but the first one i noticed is you are missing parenthesis at the end to close out the statements.

Round
(if isnull({tei.dteFileCreated}) then
(if {vtr.Mode}="LTL"
then ({vtr.TotalARAmt}-{vtr.curARAddedFee})*1.37+{vtr.curARAddedFee}
else
(if {vtr.Mode}<>"TL"
THEN (({vtr.TotalARAmt}-{vtr.curARAddedFee})*1.1+{vtr.curARAddedFee})
ELSE
(IF {vtr.Mode}="TL"
THEN (({vtr.TotalARAmt}-{vtr.curARAddedFee})*1.23+{vtr.curARAddedFee})
else
if NOT isnull ({tei.dteFileCreated}) then {tei.curARAmtwMarkup}+{tei.curFee},2)))))

 

[lbass]

Assuming that all of the 'ifs' belong to the isnull condition, then it should look like:

if isnull({tei.dteFileCreated}) then
(
if {vtr.Mode}="LTL"
then ({vtr.TotalARAmt}-{vtr.curARAddedFee})*1.37+{vtr.curARAddedFee}
else
if {vtr.Mode}<>"TL"
THEN ({vtr.TotalARAmt}-{vtr.curARAddedFee})*1.1+{vtr.curARAddedFee}
ELSE
IF {vtr.Mode}="TL"
THEN ({vtr.TotalARAmt}-{vtr.curARAddedFee})*1.23+{vtr.curARAddedFee}
) else
if NOT isnull ({tei.dteFileCreated}) then
{tei.curARAmtwMarkup}+{tei.curFee}

Not sure what this is supposed to be:

{tei.curFee},2

...so I just removed the comma and 2.

-LB