Field Cannot Be Summarzied

[Joelcc]

Hello,

I created an If Then Formula where it displays a 1 if a condition is met or 0 if not met.

@SSRProdCon=

IF(IF{@SignOnDuration} = 0 then 0 Else
(Sum ({@AvailableTime}, {VW_CFG_Staff.Staff_Name})+
Sum({@HoldTime}, {VW_CFG_Staff.Staff_Name})+
Sum({@ProdTalkTime}, {VW_CFG_Staff.Staff_Name})) /
(Sum({SignONDuration}, {VW_CFG_Staff.Staff_Name}))*100)

>=85 Then 1 Else 0

That is in GH4 . I'm trying to Sum all the 1's and enter that in GH3. Sum({SSRProdCon}) is giving me a "Field Cannot Be Summarized", and it will not let me do a Running Total or Summary.

Thanks for the help

 

[synapsevampire]

Try:

numbervar MySum;
MySum:=MySum+IF(IF{@SignOnDuration} = 0 then 0 Else
(Sum ({@AvailableTime}, {VW_CFG_Staff.Staff_Name})+
Sum({@HoldTime}, {VW_CFG_Staff.Staff_Name})+
Sum({@ProdTalkTime}, {VW_CFG_Staff.Staff_Name})) /
(Sum({SignONDuration}, {VW_CFG_Staff.Staff_Name}))*100)

Now you can display MySum at Group footer 3 using
numbervar MySum

You'll probably also want a formula in Group Header 3 to reset it:

numbervar MySum:=0;

-k