Please correct the expression

[#1]

Hi,

I have this expression in my bar chart, but not working as i expect.

Avg({<OFFER_TAT_DIFF-={'-1'}>} OFFER_TAT_DIFF)

That is, I want my chart to show the avg of OFFER_TAT_DIFF avoiding those values where OFFER_TAT_DIFF which is -1.

But even after giving the clause in expression my bar chart comes with -1 values.

Can anyone help me in reframing the expression.

[#2]

hi

try like this.. but am not sure..

=Avg(aggr({<OFFER_TAT_DIFF-={'-1'}>} OFFER_TAT_DIFF))

Regards

A'run'

[#3]

Hi

I think your expression is right.

[#4]

Actually the expression was correct.

The problem was that negative values other than -1 also used to come ...

So I actually want to restrict all values that are less than 0.

Can anyone reframe the expression ...am getting an issue with ">" sign as it is already a syntax of expression..

[#5 · Accepted solution]

Hi

Try

=Avg({<OFFER_TAT_DIFF ={">=0"}>} OFFER_TAT_DIFF)

Regards

Anders

[#6]

Hi,

Pls try below one.

Avg({<OFFER_TAT_DIFF-={'<>-1'}>} OFFER_TAT_DIFF)

Hope it will work.

Regards,

Napolean.

[#7]

Thanks