Condition in Expression

[ajsjoshua]

Dear all,

My condition CurrentNPABucket={">=4"}  doesn't works

Expression:

count(distinct {<Type={'CurrentOD'},Month=,YearMonth=, YearMonthKey ={"$(vMaxMonthSelect)"},CurrentNPABucket={">=4"}>} LOANKEY)

I am getting the same number as this expression

count(distinct {<Type={'CurrentOD'},Month=,YearMonth=, YearMonthKey ={"$(vMaxMonthSelect)"}>} LOANKEY)

[lironbaram]

hi

quite hard to understand what is the problem you try to raise

can you share sample data or explain a little more

according to your image you  only display points that are equal or bigger than 4 which is what

you try to achieve so what  is the problem?

[ajsjoshua]

Dear Liron,

Actually my CurrentNPABucket field has values 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,72 i want to find LOANKEY which are CurrentNPABucket>=4.

But this condition doesnt works.

Regards,

Joshua.

[lironbaram]

Hi Joshua

i understand your need , and on the surface your expression seems right

what exactly you display in the image , and what expression you used in the field you display