set analysis problem

[adiarnon]

hi,

i have this expression

(NOT working)

count({<Task_MS={'1'},Perf_CC=,Lead_CC={=GetFieldSelections(Perf_CC)}>}DISTINCT Task_ID)

how can i fix it?

adi

[avinashelite]

try like this:

count({<Task_MS={'1'},Perf_CC=,Lead_CC={"=GetFieldSelections(Perf_CC)"}>}DISTINCT Task_ID)

[PrashantSangle]

Hi,

Try this

count({<Task_MS={'1'},Perf_CC=,Lead_CC={"$(=GetFieldSelections(Perf_CC))"}>}DISTINCT Task_ID)

Regards

[rubenmarin]

Hi adi, you also can try this:

count({<Task_MS={'1'},Perf_CC=,Lead_CC={$(=Chr(39) & Concat(Distinct Perf_cc, Chr(39) & ',' & Chr(39)) & Chr(39))}>}DISTINCT Task_ID)

[adiarnon]

working!!

[pratap6699]

count({<Task_MS={'1'},Perf_CC=,Lead_CC={"=$(=GetFieldSelections(Perf_CC))"}>}DISTINCT Task_ID)

[adiarnon]

HI,

BUT WHEN IM NOT CHOOSING "Perf_CC"

ITS SHOW ME ALWAYS 0

I WANT IT TO BE LIKE

count({<Task_MS={'1'},Perf_CC=,Lead_CC="}>}DISTINCT Task_ID)

[PrashantSangle]

Hi,

Use if condition for it

like if(getSelectedCount(Perf_CC)>0,

count({<Task_MS={'1'},Perf_CC=,Lead_CC={"$(=GetFieldSelections(Perf_CC))"}>}DISTINCT Task_ID),

count({<Task_MS={'1'},Perf_CC=,Lead_CC=>}DISTINCT Task_ID)

)

Regards

[adiarnon]

hi,

tnx!

but i have 7 fields that i nssd to do it for them,

so i need to do 7 IFS?

IS there any other option?

[adiarnon]

and....

if the user filter 2 fields Perf_CC,Perf_ML

SO in wich if it will be?