topic Re: Help with Pivot Tabelle in App Development

Help with Pivot Tabelle

Manuel174102 — Tue, 30 Aug 2022 15:13:32 GMT

Hello People!

I need to show in a Pivot Tabelle the quantity of orders where the commision was 0.

How could I do it? I know that I would need a measure but I do not know how make the formula right.

The orders are named "VR" and the commision number is " Commision_"

I tried with if([Commission_]='0',count(VR)) but it doesnt work.

Greetings

brunobertels — Tue, 30 Aug 2022 15:28:16 GMT

try with set analysis :

Count({<[Commission_]={'0'} >} VR )

Manuel174102 — Wed, 31 Aug 2022 06:18:32 GMT

hello, it does not work. It is counting also the one which commision is higher than 0 😞

Timario — Wed, 31 Aug 2022 06:29:32 GMT

hi.

try next expression:

sum( if([Commission_]='0' or [Commission_]=0 , 1 ,0 ) )
Maybe your Commission_ is not text

SunilChauhan — Wed, 31 Aug 2022 08:37:46 GMT

Can you Please check include zero check box as in screen shot

include Zero Value

and hope fully this expression

count(if([Commission_]='0',VR))

Count({<[Commission_]={'0'}>}VR)

Count({<[Commission_]={0}>}VR)