Not getting output

[Chandu]

Hi,

I have an condition that I need to represent in combo. Im trying to use syntax: sum(sales)/sum(quantity)*quality but I'm not getting any output.

[Or]

It's hard to guess what the problem is with no sample data or explanation of the structure, but the most likely thing is that there is more than one quality value and since it's not in an aggregation function, that will result in a null.

Try e.g.

sum(sales)/sum(quantity)*sum(quality)

or

sum(sales)/sum(quantity*quality)

or whatever is appropriate for your dataset.