Sum on Formula That's Summed? 2

[supportsvc]

I am unable to do a Sum on the following formula

Q1Taxable:

If Sum ({@Q1}, {@Name}) > {@UILimit} then {@UILimit} else Sum ({@Q1}, {@Name})

Where Q1:

If {PR_EmployeeTaxHistory.CalendarMonth} IN (["01", "02", "03"]) then {PR_EmployeeTaxHistory.GrossWages} else 0

The Q1Taxable is on the Group's Header (Group is the Employee Name)
Name is (lastname, firstname)

When attempting to create another Formula to Sum(@Q1Taxalbe), I get the following error
"This field cannot be summarized"

Since it's already summarized. How do I or what do I need to do so I can sum the Q1Taxable formulated field?

 

[lbass]

Why don’t you just attach your report. You can remove employee name fields if you want.

-LB

 

[lbass]

Your report footer display formulas should read like this:

whileprintingrecords;
currencyvar Q1Tax; //NOT Q1taxable--since Q1Tax is the name of the variable you have accumulated.

Your Grand total formula in the report footer similarly should rely on the variables as follows and as shown earlier:
Whileprintingrecords;
NumberVar Q1Tax;
NumberVar Q2Tax;
NumberVar Q3Tax;
NumberVar Q4Tax;
Q1Tax+Q2Tax+Q3Tax+Q4Tax

Maybe the variable name is confusing since it is actually not a tax. But you could have named them something else, as long as you reference them consistently in all formulas.

-LB

 

[supportsvc]

sorry, I am confused

it is Q1Tax

as you can see in the actual report provided, it shows

//@Eval
Whileprintingrecords;
[highlight #FCE94F]currencyvar Q1Tax;
currencyvar Q2Tax;
currencyvar Q3Tax;
currencyvar Q4Tax;[/highlight]
Q1Tax:= Q1Tax + {@Q1taxable};
Q2Tax:= Q2Tax + {@Q2taxable};
Q3Tax:= Q3Tax + {@Q3taxable};
Q4Tax:= Q4Tax + {@Q3taxable};

and the Report footer now is and is producing a more seeming valid total. $1,028,903.29. THe above still showing $0

Whileprintingrecords;
CurrencyVar Q1Tax;
CurrencyVar Q2Tax;
CurrencyVar Q3Tax;
CurrencyVar Q4Tax;
Q1Tax+Q2Tax+Q3Tax+Q4Tax

see attached

thank you

 

[lbass]

That's because you don't have the correct variable names in your report footer totals. Take a look at {@TtlQ1taxable}. You need to update the variable name to say Q1tax instead of Q1taxable. Same with your other report footer green formulas.

-LB

 

[supportsvc]

Ok! got it working now!

Thank you so much!