Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have got the above Chart, all i want to do is to Count how many time IBT & Sales are Zero.
i above example we have this situation 6 times so it should return 6.
Any Help will be appreciated.
Sorry I forgot to add PLEASE.
What formula is in the expression now? Do you want 6 displayed for all rows? If so, it would be something like:
=count({<IBT={0}, Sales={0}>} <TOTAL> [unique field to count])
This simple expresion ....
=Sum(if(IBT=0 and Sales=0, 1, 0))
try it
Saludos,
Enrique Colomer
Thanks Josh for your Help, I used your formula in the expression but its not changing according to the selection
I have used count ({<[IBT]= {0}, [SALES]={0}>} [DWH_SKU_REF_NO]). What I actually want to achieve is Among the total number of Branches which is 18 how many branches have the stock and sales which in this case will be 18-6=12
and I want to have this thing in another chart which is next TAB.
it was looking easy but looks like its getting more difficult.
If you can please help me on this I will be very thankful to you.
create problem expression:
we can use column(1), column(2) conditions
Thanks Sasi is there way you can write any example by seeing the above CHART, Please.