Empower not dealing with ABS( in CF
So, I have some CFs for CU AV calcs. Worked fine on another installation, not working here.
Basic problem is the ABS(MAveragePercentClaim) portion. It keeps spitting out the AveragePercentClaim instead of a much smaller number. M is being calculated correctly and AveragePercentClaim is being calculated correctly.
I tried ABS(1*M+AveragePercentClaim)  no help.
I've tried additional parentheses. No help. Empower just cannot add these terms correctly!
I even tried 1*M+AveragePercentClaim and I get AveragePercentClaim instead of a small number (which should be negative, in this case as M>AveragePercentClaim).
Any suggestions?
Basic problem is the ABS(MAveragePercentClaim) portion. It keeps spitting out the AveragePercentClaim instead of a much smaller number. M is being calculated correctly and AveragePercentClaim is being calculated correctly.
I tried ABS(1*M+AveragePercentClaim)  no help.
I've tried additional parentheses. No help. Empower just cannot add these terms correctly!
I even tried 1*M+AveragePercentClaim and I get AveragePercentClaim instead of a small number (which should be negative, in this case as M>AveragePercentClaim).
Any suggestions?
0
Best Answer

Might be the alphabetical naming of the custom fields. CFs that depend on each other are processed first in the order of capitals (ZZZ is calculated before aaa) so your AveragePercentClaim is calculated first then M is calculated but what did you name the CF ABS(MAveragePercentClaim)? Make sure is starts with a letter greater than M, say for example SubtractedValue or similar. Whenever Empower sees the function "Summarize Custom Fields" in a sample set, it goes back to the top of the sample set and looks for labels and fields to add up all your averages before spitting out a final result. I suspect while all this is going on, the custom field you have for ABS(MAveragePercentClaim) is tapping its fingers impatiently waiting for a value for M which hasn't been calculated yet!
I hope this works for you, good luck.
0
Answers
Best answer I've seen in quite a while. Thanks lots!
I wonder if this is in the help or training docs I've got access to...
Yes, this is outlined in Empower 3 help not sure the exact wording but most likely under "Intersample Summary Syntax Rules" or similar.
Would CFs named aa, AA, zz, ZZ, 01, 02 be figured in the order:
AA, ZZ, aa, zz, 01, 02 or
01, 02, AA, ZZ, aa, zz?
I think simply ABS((xy)) might have worked?
Or maybe ABS can only work of single field so you needed to save that xy value in the DB first