Conditional formatting in a Group Type Footer

[kcdoell]

Hello:

I have a report that is grouped by Product Type. In the detail section, I am currenly focusing on the following fields:

[GWP]
[Binding_Percent age]

In the Product Type footer I placed two unbound text boxes. The first on is called "SumofGWP" with its control source set to[code=vb]=Sum([GWP]) [/code]. That works no problem.

The second box is called "Sum_ByPer_GWP" . This needs to sum only the [GWP] whose [Binding_Percent age] is >= 75. So I thought I would set the control source to: [code=vb]=Sum(IIf([GWP]="[Binding_Percent age] >= 75",0)) [/code] , but I get an error when I run the report indicating that the

[code=text]
This expression is typed incorrectly, or it is too complex to be evaluated. Try simplifying the expression..... ..[/code]

I have the "RunningSum " properties of my [Sum_ByPer_GWP] set to "No"

Any ideas what I am missing?

Thanks,

Keith.

[kcdoell]

I even tried this as well:

[code=vb]=IIf([Binding_Percent age]>=75,Sum([GWP]),0) [/code]

No errors, calculates but not filtering by [Binding_Percent age] parameter.

Thanks,

Keith.

[nico5038]

I even tried this as well:

[code=vb]=IIf([Binding_Percent age]>=75,Sum([GWP]),0) [/code]

No errors, calculates but not filtering by [Binding_Percent age] parameter.

Thanks,

Keith.

Your first statement:
[code=vb]=Sum(IIf([GWP]="[Binding_Percent age] >= 75",0)) [/code]
is missing the False parameter and the second has the sum in the wrong place...

Guess you need:
[code=vb]
=Sum(IIf([GWP]="[Binding_Percent age] >= 75",[GWP],0)) [/code]

Nic;o)

[kcdoell]

Hello:

Thanks for the reply. I place the following, as suggested, in the control source.
[code=vb]=Sum(IIf([GWP]="[Binding_Percent age] >= 75",[GWP],0))[/code]
but when I ran it, the following message came back to haunt:
[code=text]This expression is typed incorrectly, or it is too complex to be evaluated. Try simplifying the expression..... ..[/code]

Do you see anything missing?

Thanks,

Keith.

[kcdoell]

Okay, I have been playing with this. When I put in the "" around the controls:
[code=vb]=Sum(IIf("[GWP]"="[Binding_Percent age] >= 75","[GWP]",0))[/code] the error went away and the report ran. But the result that was displayed was zero (0). I can see that I had values of >=75 so it should have calculated something. Any ideas why it did not work??

Thanks,

Keith.

[nico5038]

Okay, I have been playing with this. When I put in the "" around the controls:
[code=vb]=Sum(IIf("[GWP]"="[Binding_Percent age] >= 75","[GWP]",0))[/code] the error went away and the report ran. But the result that was displayed was zero (0). I can see that I had values of >=75 so it should have calculated something. Any ideas why it did not work??

Thanks,

Keith.

Hmm, I assumed that the variable GWP held a textstring, guess you need:

=Sum(IIf([Binding_Percent age] >= 75,[GWP],0))

There might also be a "problem" with the percentage, as you might see 75, but internally 0.75 is recorded....

Nic;o)

[kcdoell]

Hmm, I assumed that the variable GWP held a textstring, guess you need:

=Sum(IIf([Binding_Percent age] >= 75,[GWP],0))

There might also be a "problem" with the percentage, as you might see 75, but internally 0.75 is recorded....

Nic;o)

That was it! Thanks a million. I new I was close to getting there but I am still learning. In fact my [Binding_Percent age] is a drop down menu with a list of 0,50,75,or 100 so the 0.75 scenario will not be an issue but of course it could have been.

Thanks so much!!

Keith ;-)