2 Replies Latest reply on Jun 15, 2016 11:33 AM by Hiran Samarthyam Haranatha Babu

# Calculation and grouping  Or combining aggregate and non aggregate fn in one Logical statement

i want to set the color of the 2nd graph such that if average waste % in 43 is greater than 7.15% then it has to be red, else the bar has to be green.

for 45 it has to be red when average waste %  is greater than 2.7% and green otherwise. so for each machine(43, 45,46,47 and 48) i want to color it based on a preset value (7.15%, 2.70%, 3.75%, 3.45% and 3.05%). how do i do this?

I tried writing IF press=43 and avg(waste%) < 7.15 THEN "good" ELSE "bad"

but i got an error saying it can combine an aggregate and non aggregate function together.

• ###### 1. Re: Calculation and grouping  Or combining aggregate and non aggregate fn in one Logical statement

Have you tried aggregating your pg ct wth Max(Press) or Avg to satisfy the aggregate consistency?

1 of 1 people found this helpful
• ###### 2. Re: Calculation and grouping  Or combining aggregate and non aggregate fn in one Logical statement

Wow! Worked like a charm. Thank you