Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to Count orders with discount only.
I have field names [Order number] ,[Sales amount] and [Discount amount].
Thanks in advance.
Hi,
Use the below code.
Count(Distinct If([Discount Amount] > 0 , [Order Number]))
Thanks,
Venkata Sreekanth
hi you can do it like this
count({<[Discount amount]={">0"}>}distinct [Order number])
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 .
Hi,
Use the below code.
Count(Distinct If([Discount Amount] > 0 , [Order Number]))
Thanks,
Venkata Sreekanth
Thank you Sreekanth