Nested Count

[dhanu_today]

Hi Everyone,

Can any one help me as per the attached requirement.I have to develop the logic in front end level because the sample data whatever the fields we have is coming from various tables.

Thanks in advance,

Dhanu

[dhanu_today]

Any one is there for hint .....

Thanks,

Dhanu

[MK_QSL]

What is the COUNT? i.e what is the logic you used to count?

[dhanu_today]

Thanks...For in the exp1 i have counted the value based on the No. of accounts.

For Exp2--the sum of balances and for exp3 is sum(balance)/Count(accounts)

Main logic i have to do is based on the exp3 values i have to create the bucket and their respective no. of accounts.

e.g. if exp3 is 5000 then we have to show the how many accounts are in that bucket range.

Refer the attached output.

Let me know in case of any information my side.

Thanks ,

Dhanu

[MK_QSL]

Segemnt	Count(Accounts)	sum(Balance)	EXP2/EXP1	<= 0 and <2000	>=2000 AND <30000	>=30000 AND <100000	>= 100000
PRB	7	180000	25714.29	0	2	0	0
SB	6	354245	59040.83	0	0	2	0
CBC	9	183581	20397.89	0	1	0	0

Sorry, still have doubt.

Can you tell me how the bold and underlined value coming?

The logic is apply to expression 3? or I am missing something?

[dhanu_today]

Thanks for your time...The Bold and underline values(2 in PRB) are the count of accounts which are having the balance 20000 and 28000(in the Data of excel) so they are in the bucket of >=20000 and <100000.

Same wise for SB and CBC also.

Its my mistake in the out put sheet i wrote >=2000 instead of >=20000.

Let me know for any clarifications.

[MK_QSL]

You can use below expressions

COUNT({<Balance = {'>=0<20000'}>}Accounts)

COUNT({<Balance = {'>=20000<30000'}>}Accounts)

COUNT({<Balance = {'>=30000<100000'}>}Accounts)

COUNT({<Balance = {'>100000'}>}Accounts)

Let me know if these are not working...

[dhanu_today]

Let me try the same and will get back....

[dhanu_today]

Thanks ...But  script is not filling my requirement....It is giving the count of accounts using the field balance and for bucket as well.

We have to consider the exp3 result as balance(like derived balance) and then we have to count the no. of accounts based on the exp3 result bucket(not on the basis of existing balance).

Let me know for any clarifications.

Thanks,

Dhanu

[MK_QSL]

Ok... using the above mentioned criteria, let me know that the result you have shown in the excel file is accurate or the assumed one?