Set Analysis Syntax

[#1]

This does not work:

Count({$<RebateAmtReported={"=0"}>} DISTINCT TransactionID)

But this does:

Count({$<RebateAmtReported={"<>0"}>} DISTINCT TransactionID)

Why?

I'm trying to get a count of transactions w/rebates vs. transactions without rebates.

[#2]

This should work:

Count({$<RebateAmtReported={"0"}>} DISTINCT TransactionID)