I have been struggling with set analysis for couple of hours .
Below is my expression
Set Expression:
Sum(ActualDay)-Sum(History Day)
/
Sum(History Day)
Please find the data in attached document .
In the attachement 'Assumed answer' is the desired result
'R/H % Daily ' is displaying null value
I am getting wrong outputs with the above expression. The expression is correct .I have cross checked each individual aggregation when i combining the all the three expression for growth it is giving me wrong results .i think it was with brackets in the epxression i was going wrng.
for eg:
the expresiion is displaying '-'
but when i am calculating individually it is some where close to -16%
That's hard to answer without knowing more details about your data, model and context of the expression.
It would be best if you could upload a small sample QVW that demonstrates your issue.
At least post the output of each individual sum, the context (used in a chart? with which dimensions and user selections?) and explain how the two fields are related to each other and how your variable is defined.
You say you have crossed checked each individual calculation. What does that mean? Did you calculate the same the two sub expressions in the same chart - a straight table or pivot table I would presume?
What does the vMTD variable contain? How is it defined?
What are each of these sums come out to be individually? May be we can see what number it is calculating by looking at the numbers for each of them separately.
