Set Analysis for counts

[#1]

Hi everybody

I have to do a expression for following scenario:

Month of Juy - 1000 Accounts Created  - Count (Account Id for the month of July)

I would like to have the transaction for those 1000 accounts from July 1st to August 31 st

No  of Transactions for Accounts created in month of July for the period of July 1st - August 31st

Thnank you,

Abhi

[#2]

hmm... if you ask me, I will do it by aggregations other than Set analysis...

SUM(Aggr(if(AccCreateDate>='1-Jul' AND AccCreateDate<= '31-Aug', 1, 0), TransactionsID))

What I do here is aggregating through the transactions, if the Account create date is between 1-Jul to 31- Aug return 1 else return 0. After that you can just sum up everything, it should return you what you need.

[tresesco]

I guess you have to use indirect set analysis p().

[sushil353]

Hi,

Please provide some example/sample application or data to understand your requirement.

HTH

Sushil

[sujeetsingh]

Seems you need to explain the scenario .

you can use sum(with If expressions)