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?
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
when i am trying to do x-y 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'
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 X-Y. then it should work.
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
Its just like a guessing game.
Can you mock up some data if you cannot attach packaged workbook. so we can help you better.
will try to get some data