Not getting output

Chandu — Wed, 06 Apr 2022 10:11:02 GMT

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.

Re: Not getting output

Or — Wed, 06 Apr 2022 10:14:00 GMT

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)

sum(sales)/sum(quantity*quality)

or whatever is appropriate for your dataset.

topic Not getting output in App Development

Not getting output

Re: Not getting output