Set analysis

[ajsjoshua]

Dear all,

I have a field called Login_Status

When i use it in set analysis

=Count({<Month=,YearMonth=, YearMonthKey ={"$(vMaxMonthSelect)"},Login_Status={'InProcess'}>} Distinct Login_AppNo)

it doesn't works.

But when i use it in Filter pane and select InProcess it works.

Will it be a linking issue?

Regards,

Joshua.

[jubarrosor]

Hi Joshua:

It's difficult if I can't review de qvf. Could you upload it?

The syntax seems correct.

Best Regard,

Juan P. Barroso

[agigliotti]

let's try to make it simpler as below:

first text box expression: Count( {< Login_Status = {'InProcess'} >} Distinct Login_AppNo )

second text box expression: Count( Distinct Login_AppNo )

and check if you get the same result filtering 'InProcess' as field value in both text box.

[ajsjoshua]

Dear Andrea,

I am getting 0 for Count( {< Login_Status = {'InProcess'} >} Distinct Login_AppNo )

and for Count( Distinct Login_AppNo ) i am getting 513.

Regards,

Joshua

[agigliotti · Accepted solution]

'Inprocess' is not equal to 'InProcess'