i'm using a formula in my group footer which is basic.

If {field} = 1 And {field} = 2 Then -(Sum({field}))

when i run the report it's coming up with some super crazy number that i can't even find anywhere in the report to see how it's making this number.

i can force it to pass through anything i tell it {field} is equal to but i'm stuck on why the formula isn't working.


any thoughts?

any help would be great!

thank you!

well, i thought that only when i manually sum all the rows it's coming up with a number way less.

what i tried was switching up the formula to

Select {ELaborDist.det}
    Case "T"
    : (
        If {ELaborDist.cd} = "D" Then
            Offset := Sum({ELaborDist.amount}) * -1
        );

it's still giving me the same figure for each group footer which is nowhere near the number it should be returning.

thoughts?

yes, you are correct. this is a GL import file for a client that i'm working on and have gotten the data in the rows and have it assigned values then need to show it summed per group based on the above formula. i am using shared variables throughout the report i'm just not sure on how to show the sum i'm looking for in the footer for each group. 

Thank you! it is now summing per group although it is negating the formula and just giving me the sum. it should be returning the sum of the fields outlined in the code here:

Shared NumberVar Offset;

Offset :=

Select {ELaborDist.det}
    Case "T"
    : (
        If {ELaborDist.cd} = "D" Then
            Offset := Sum({ELaborDist.amount}, {EPayHist.id}) * -1
        );

epayhist.id is the group and it should only sum the total of elabordist.amount where the other columns are 'T' and 'D'.

i really do thank you for your help. i'm racking my brain over here.

the part that i was missing the was the gf pass through.

DBlank you are awesome!

thank you!