I need to have multiple IF statements run against a field and I'm looking for the best way to do it.

this is what i have now but there is an error here.


ToText({ELaborDist.amount}, 2, "") +

If {ELaborDist.det} = 'E' Then
    {ELaborDist.amount}
End If +

If {ELaborDist.det} = 'D' Then
    {ELaborDist.amount} * -1
End If +

If {ELaborDist.det} = 'T' And {ELaborDist.cd} = 'D' Then
    {ELaborDist.amount}
End If +

If {ELaborDist.det} = 'T' And {ELaborDist.cd} = 'C' Then
    {ELaborDist.amount} * -1
End If;

any help would be greatly appreciated.

You can nest if statements, but I would probably use a Switch statement here.  It looks something like this:

it absolutely works! i was piecing this together as your email came across and it looks like they both do the same thing. although i like your code better as it's cleaner.

shared numbervar Amount;

Amount := 0;

 

Select {ELaborDist.det}

    Case "E"

    : Amount := {ELaborDist.amount}

    Case "D"

    : Amount := Sum({ELaborDist.amount}) * (-1)

    Case "T"

    : (

        If {ELaborDist.cd} = "D" Then

            Amount := {ELaborDist.amount}

        Else

            Amount := -(Sum({ELaborDist.amount}))

        )

well now that i have the numbers showing as they need to. i need to create 2 separate footers for the report.

one will show the sum for the amount where det = t and cd = d and the other will only run if it sees netcheck is >0.

i wrote the first footer but it doesn't seem to want to do the math. is there a certain place that i should put it or run it?

thanks so much for all of your help.