Count orders with discount

[madhuqliklondon]

Hi All,

I want to Count orders with discount only.

I have field names [Order number] ,[Sales amount] and [Discount amount].

Thanks in advance.

[YoussefBelloum · Accepted solution]

Hi,

you can try this:

Count( {<[Order number]={"=sum( [Discount amount])>0"}>} [Order number])

[Digvijay_Singh]

May be this -

Count({<[Discount amount={">0"}>}distinct [Order number] )

[shiveshsingh]

Count(if([Discount amount].)>0,[Order Number])