Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Trying to put together two (or more) fields added together which are greater than 0 to give a result.
The set analysis so far for a single field:
COUNT({$<SALES_TOTAL={">0"}>} SALES_TOTAL)
It's probably something really simple, can't seem to find it anywhere.
Thanks.
What is the other field?
Other field is named: SALES_TOTAL_2
Exactly the same sort of field, just another number.
How about this:
Count({$<SALES_TOTAL={">0"}>+<SALES_TOTAL_2={">0"}>} SALES_TOTAL)
Great stuff, one problem.
It brings back more than it should.
If I wanted to exclude other records from interfering with the set analysis, is there a way to exclude other fields like this?
Thanks.
Exclude other fields? Can you elaborate a little because I am not sure I understand your question