I'm surprised that only the second attribute is being rejected. In my mind, TOTAL should not work at all in the script, because it's a Chart feature.
In the script, we use GROUP BY load for aggregating data:
SUM( [2014 Employment]) as CIPbyGeoidWage
Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!
Is there a way to sum based on aggregating by two fields in the load script? From what i can tell, the formula works if I only have one field like, <cip>, but i need the data aggregated by both (<cip, geoid>).
could you post a sample QVW or script that demonstrates a Sum(TOTAL FIELD) or Sum(TOTAL<cip> FIELD)?
As already pointed out by others I don't think TOTAL qualifier is allowed in the script (don't get confused by the syntax checker without running the script).
If you made it work, I would be interested to see your sample.