
1. Re: urgent calculation
ann.stolzman Feb 18, 2016 3:57 PM (in response to g Vish)g Vish,
Do you have a sample packaged workbook so we can see the data itself and help you resolve this? Is one of those columns a calculated field and the other isn't?
Ann

2. Re: urgent calculation
g Vish Feb 18, 2016 4:22 PM (in response to ann.stolzman)Hi ann , unfortunately cant post the workbook. One of them is score% Which is a calculated field using c= sum(a)/Sum(b)
the other one has calculated field formulae exclude(xyz):c

3. Re: urgent calculation
ann.stolzman Feb 18, 2016 4:34 PM (in response to g Vish)I'm not quite clear on your formulas, can you help me clarify them to make sure I understand them properly.
Score is calculated as sum([value a])/sum([value b]), correct? I assume that you're using c as the name of the formula, so I'm going to call it [score] here for clarity.
The second calculation... is that an LOD? Is it formatted like this: {Exclude [Value x] : [score]} Or do you have 3 values in that formula, in which case it would be {Exclude [Value x],[Value y],[Value z] : [score]}
You could use the Superstore dataset to try and mock up what you're trying to do, also.
A

4. Re: urgent calculation
g Vish Feb 18, 2016 10:07 PM (in response to ann.stolzman)sorry for not making it clear. since i have defined it as attribute it is nt working.I had to change it to aggregate measure and then perform subtraction. I really appreciate your time and effort.

5. Re: urgent calculation
Jonathan Velarde Feb 18, 2016 11:44 PM (in response to g Vish)Good Day!
Hi.., just to share my experience about this. Problem in Calculation between two aggregated fields is still possible.
You need to do is to determine the field is not the same with the other one before you do the difference calculation.
Sample:
A%B% it says cannot do calculation due to aggreate and non aggregate. meaning 1 of the calculated field here is a nonaggregate. You just need to aggregate the other field to be able to accept this calculation.
Hopefully this could help.
Regards,
Jonathan B. Velarde