multiple AND condition in set analysis

[Anonymous]

Find the value invoice processed between dates

When I am apply this formula “=Count(distinct if((TransDate>='01/01/2008')and (TransDate<='11/15/2008'), [Invoice
Number]))” am getting value 27726.

When apply same in set analysis concept I did not get same value count({1<TransDate={'>=01/01/2008'},TransDate={'<=11/15/2008'}>} DISTINCT [Invoice
Number]).

Please help me on this . Can you send some example on how to use multiple ‘AND’ condition in set analysis

[tresesco · Accepted solution]

Try like:

count({1<TransDate={'>=01/01/2008 <=11/15/2008'}>} DISTINCT [Invoice
Number]).

[Anonymous]

HI Tresesco

It working perfect. Thank you for your prompt reply.

[rohan_mulay]

Hi tresesco,

We have a scenario where we want sum of Referrals for those Employees where City is 'mumbai' as well as 'pune'.

Referrals, Employee, City

    1, abc, mumbai

    2, pqr, pune

    1, lmn, mumbai

    4, xyz, banglore

    5, abc, pune

[jonathandienst]

This is a new query. I suggest that you start a new thread as this on has already been answered.