Forum Discussion
leebell
Apr 21, 2021Copper Contributor
Trying to create query for commision on products, nothing coming up when ran, what am i doing wrong?
George_Hepworth
Apr 22, 2021Silver Contributor
It looks like you are trying to use a calculated value as a criteria in the query. It's in the same row as the "DVD" criteria.
That means your query says, "Return records where the Product is DVD and the Commission is equal to the Price * .4"
If you have records that already meet both criteria, then this query would return those records.
However, if your intention is to CALCULATE a commission for DVD;s, that's going to be a different query.