Issue with Multiple Count condition

[Anonymous]

Hi

I have written the below condition in calculated field.Its nor showing an output or error.

I am able to get the output if i enter single condition(i.e

Count(IF([(CASEWHENAL1.BUS_LINE='PAS'THEN'PAS'WHENAL1.BUS_LINE='SMAF'THEN'PAS'WHENAL1.BUS_LINE='UMA'THEN'PAS'WHENAL1.BUS_LINE='UMAT'THEN'PAS'WHENAL1.BUS_LINE='BDI'THEN'PAS'WHENAL1.BUS_LINE='SMEI'THEN'PAS'WHENAL1.BUS_LINE='SMLC'THEN'PAS'WHENAL1.BUS_LINE='DMA'THEN'PA]='Non PAS' and REG_CAT_COARSE='PERSONAL' and [(CASEWHEN(SUM(AL2.TXN_CNT))>0THEN'Y'ELSE'N'END)]='N',ACCT))/

Count(total(IF([(CASEWHENAL1.BUS_LINE='PAS'THEN'PAS'WHENAL1.BUS_LINE='SMAF'THEN'PAS'WHENAL1.BUS_LINE='UMA'THEN'PAS'WHENAL1.BUS_LINE='UMAT'THEN'PAS'WHENAL1.BUS_LINE='BDI'THEN'PAS'WHENAL1.BUS_LINE='SMEI'THEN'PAS'WHENAL1.BUS_LINE='SMLC'THEN'PAS'WHENAL1.BUS_LINE='DMA'THEN'PA]='Non PAS' and REG_CAT_COARSE='PERSONAL',ACCT))))

as soon as i add the rest condition,its showing null.

Code:

Count(IF([(CASEWHENAL1.BUS_LINE='PAS'THEN'PAS'WHENAL1.BUS_LINE='SMAF'THEN'PAS'WHENAL1.BUS_LINE='UMA'THEN'PAS'WHENAL1.BUS_LINE='UMAT'THEN'PAS'WHENAL1.BUS_LINE='BDI'THEN'PAS'WHENAL1.BUS_LINE='SMEI'THEN'PAS'WHENAL1.BUS_LINE='SMLC'THEN'PAS'WHENAL1.BUS_LINE='DMA'THEN'PA]='Non PAS' and REG_CAT_COARSE='PERSONAL' and [(CASEWHEN(SUM(AL2.TXN_CNT))>0THEN'Y'ELSE'N'END)]='N',ACCT))/

Count(total(IF([(CASEWHENAL1.BUS_LINE='PAS'THEN'PAS'WHENAL1.BUS_LINE='SMAF'THEN'PAS'WHENAL1.BUS_LINE='UMA'THEN'PAS'WHENAL1.BUS_LINE='UMAT'THEN'PAS'WHENAL1.BUS_LINE='BDI'THEN'PAS'WHENAL1.BUS_LINE='SMEI'THEN'PAS'WHENAL1.BUS_LINE='SMLC'THEN'PAS'WHENAL1.BUS_LINE='DMA'THEN'PA]='Non PAS' and REG_CAT_COARSE='PERSONAL',ACCT,

Count(IF([(CASEWHENAL1.BUS_LINE='PAS'THEN'PAS'WHENAL1.BUS_LINE='SMAF'THEN'PAS'WHENAL1.BUS_LINE='UMA'THEN'PAS'WHENAL1.BUS_LINE='UMAT'THEN'PAS'WHENAL1.BUS_LINE='BDI'THEN'PAS'WHENAL1.BUS_LINE='SMEI'THEN'PAS'WHENAL1.BUS_LINE='SMLC'THEN'PAS'WHENAL1.BUS_LINE='DMA'THEN'PA]='Non PAS' and REG_CAT_COARSE='PERSONAL' and [(CASEWHEN(SUM(AL2.TXN_CNT))>0THEN'Y'ELSE'N'END)]='Y',ACCT))/

Count(total(IF([(CASEWHENAL1.BUS_LINE='PAS'THEN'PAS'WHENAL1.BUS_LINE='SMAF'THEN'PAS'WHENAL1.BUS_LINE='UMA'THEN'PAS'WHENAL1.BUS_LINE='UMAT'THEN'PAS'WHENAL1.BUS_LINE='BDI'THEN'PAS'WHENAL1.BUS_LINE='SMEI'THEN'PAS'WHENAL1.BUS_LINE='SMLC'THEN'PAS'WHENAL1.BUS_LINE='DMA'THEN'PA]='Non PAS' and REG_CAT_COARSE='PERSONAL',ACCT,

Count(IF([(CASEWHENAL1.BUS_LINE='PAS'THEN'PAS'WHENAL1.BUS_LINE='SMAF'THEN'PAS'WHENAL1.BUS_LINE='UMA'THEN'PAS'WHENAL1.BUS_LINE='UMAT'THEN'PAS'WHENAL1.BUS_LINE='BDI'THEN'PAS'WHENAL1.BUS_LINE='SMEI'THEN'PAS'WHENAL1.BUS_LINE='SMLC'THEN'PAS'WHENAL1.BUS_LINE='DMA'THEN'PA]='Non PAS' and REG_CAT_COARSE='IRA' and POE_CAT='RETIRE INT ROLLOVER','IRA - Internal Rollover' and [(CASEWHEN(SUM(AL2.TXN_CNT))>0THEN'Y'ELSE'N'END)]='N',ACCT))/

count(total(IF([(CASEWHENAL1.BUS_LINE='PAS'THEN'PAS'WHENAL1.BUS_LINE='SMAF'THEN'PAS'WHENAL1.BUS_LINE='UMA'THEN'PAS'WHENAL1.BUS_LINE='UMAT'THEN'PAS'WHENAL1.BUS_LINE='BDI'THEN'PAS'WHENAL1.BUS_LINE='SMEI'THEN'PAS'WHENAL1.BUS_LINE='SMLC'THEN'PAS'WHENAL1.BUS_LINE='DMA'THEN'PA]='Non PAS' and REG_CAT_COARSE='IRA' and POE_CAT='RETIRE INT ROLLOVER','IRA - Internal Rollover' ,ACCT,

Count(IF([(CASEWHENAL1.BUS_LINE='PAS'THEN'PAS'WHENAL1.BUS_LINE='SMAF'THEN'PAS'WHENAL1.BUS_LINE='UMA'THEN'PAS'WHENAL1.BUS_LINE='UMAT'THEN'PAS'WHENAL1.BUS_LINE='BDI'THEN'PAS'WHENAL1.BUS_LINE='SMEI'THEN'PAS'WHENAL1.BUS_LINE='SMLC'THEN'PAS'WHENAL1.BUS_LINE='DMA'THEN'PA]='Non PAS' and REG_CAT_COARSE='IRA' and POE_CAT='RETIRE INT ROLLOVER','IRA - Internal Rollover' and [(CASEWHEN(SUM(AL2.TXN_CNT))>0THEN'Y'ELSE'N'END)]='Y',ACCT))/

count(total(IF([(CASEWHENAL1.BUS_LINE='PAS'THEN'PAS'WHENAL1.BUS_LINE='SMAF'THEN'PAS'WHENAL1.BUS_LINE='UMA'THEN'PAS'WHENAL1.BUS_LINE='UMAT'THEN'PAS'WHENAL1.BUS_LINE='BDI'THEN'PAS'WHENAL1.BUS_LINE='SMEI'THEN'PAS'WHENAL1.BUS_LINE='SMLC'THEN'PAS'WHENAL1.BUS_LINE='DMA'THEN'PA]='Non PAS' and REG_CAT_COARSE='IRA' and POE_CAT='RETIRE INT ROLLOVER','IRA - Internal Rollover' ,ACCT

))))))))))))

[sunny_talwar]

What are you chart dimensions here?

[Anonymous]

ITS NOT WORKING OUT.....Because i wanted to find the division and the output has to be a decimal

[sunny_talwar]

What is not working? I have not even given any solution

[Anonymous]

the condition wtever i ve mentioned in the starting of the discussion is not working that is only i meant....

[sunny_talwar]

I am not sure I follow what isn't working? I have not given you anything... but I did ask you something.... you have not responded to my question

[Anonymous]

To find the division count between the conditions .Let me know if you need more clarification

[sunny_talwar]

Yes, I do need a lot of clarification ...

What is your dimension here? How does your data look like? What is the expected output from the data? Can you share some raw data with the expected output from it?