
1. Re: Need help on comparing 2 calculations for conditional formatting
. Indumon Nov 13, 2013 3:55 AM (in response to ravi.vankayala)Hi Krish, It is really difficult to understand the problem without seeing the data and calculation. Can you upload some sample data or a packaged workbook?

2. Re: Need help on comparing 2 calculations for conditional formatting
ravi.vankayala Nov 13, 2013 4:13 AM (in response to . Indumon)hi indumon,
sorry i couldn't get packaged workbook but i will explain what i meant
one calculation say is done x=ZN(([DAYS (BB)]))/ZN(COUNT([DAYS])) this returns some percentage
another calculation is done like y=
IF [column1] = 'value' then [column2] this returns a value
END
when i am trying to do xy i get a error as cannot mix aggregate and non aggregate arguments in function
so i added attr for x calculation but i am not getting correct value
IF attr(y)>=15 then 'green'
elseif x <=0.02 then 'yellow'
else 'red'

3. Re: Need help on comparing 2 calculations for conditional formatting
. Indumon Nov 13, 2013 4:33 AM (in response to ravi.vankayala)Hi Krish,
As per your calculation of X is aggregated using Count(), but y is not aggregated. Use sum, avg .. any appropriate aggregate function for y to do XY. then it should work.

4. Re: Need help on comparing 2 calculations for conditional formatting
ravi.vankayala Nov 13, 2013 5:00 AM (in response to . Indumon)hi indumon,
i added attr but data is not coming correctly. using the same calculation i am trying changing the color of the line using some conditions but it is not working correctly

5. Re: Need help on comparing 2 calculations for conditional formatting
. Indumon Nov 13, 2013 5:05 AM (in response to ravi.vankayala)Its just like a guessing game.
Can you mock up some data if you cannot attach packaged workbook. so we can help you better.

6. Re: Need help on comparing 2 calculations for conditional formatting
ravi.vankayala Nov 13, 2013 5:21 AM (in response to ravi.vankayala)will try to get some data