CountIFS

mumer_88 — Sat, 16 Nov 2024 02:10:50 GMT

Hei

i have the following data som i want in Qlick view

i have use the countifS in the cloumn"Is OK" the conditions i used was,

First of all alle orders that has order type "*Webordre"
No. of Count in the column "sales document" per order = No. of Count in the column "Bilags number"
in addition if there is value in the Column "Delivery" that is also "Is OK" although this has no values in the column "Bilags number"

the commands i used in Excel was

• =COUNTIFS(V:V;V2)
• =COUNTIFS(V:V;V2;BH:BH;"OK")
=BE:BE-BF:BF (should only filter about the values if the difference is 0, )

Re: CountIFS

mumer_88 — Sat, 19 Oct 2019 20:21:18 GMT

i am using this statement but it says error in statement

If(Count(TOTAL <Sales document>Sales document) = sum({Count(TOTAL <Bilags number>Bilags number)}),1)