Are [Rate] and [Goal] aggregates? Without seeing the actual data my first thought would be to wrap them in an appropriate aggregate (probably SUM or AVG) depending on your data.
Did that help?
If this post assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Is [Rate] and [Goal] the same datatype and the same order of magnitude ?
Usually in this sort of situation I create a new sheet showing [Rate], [Goal] and [the calculated field] to see where the problem is in the logic.
Could it be a aggregated/non-aggregated issue ?
Some sample data would be great if you need more help
This is the current months data so, it selected by Max Date.
The rate is simple num/denom =Rate for numerous measure.
There are 6 locations and one of them is the GOAL.
The goal is a national benchmark which changes between each measure.
So, I created calculation of Goal is culled by
IF ATTR([Location]="GOAL") THEN ([Rate]) END
My table design is all locations are columns and the measures are rows with the T label being AGG(Rate)
I have add an attachment.
Demo_Calc.twbx 11.5 MB