Count orders only 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.

[lironbaram]

hi you can do it like this

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

[madhuqliklondon]

Hi,

I am counting orders with count(DISTINCT [Order number]) and orders with discount  with count({<[Discount amount]={">0"}>}distinct [Order number])  , for some reason I have same count of number of orders in both .

[Anonymous · Accepted solution]

Hi,

Use the below code.

Count(Distinct If([Discount Amount] > 0 , [Order Number]))

Thanks,

Venkata Sreekanth

[madhuqliklondon]

Thank you Sreekanth