Set Analysis with Greater than and Less than

[tmumaw]

Thought I had the syntax down, but I guess I don't. Need a little help.

Thanks Thom

sum({<{"len[Cancel Reason] > 0, [Cancel Reason <>{14}"}>} [Non Accepted Sales])

I want to sum Non Accepted Sales if the length of my cancel reason is greater than 0 and cancel reason not equal to 14.

[#2]

I think is something like this:

sum({$<[Cancel Reason]={len(Cancel Reason) > 0}, [Cancel Reason]=-{14}>} [Non AcceptedSales])

[#3]

I no tested.....the len part i think is wrong.....i will try and post again!!!!

[pover]

Try something like this

sum({$<[Cancel Reason] -= {14} * {"=len([Cancel Reason])<0"}>} [Non Accepted Sales])

or

sum({$<[Cancel Reason] = {"=[Cancel Reason] = 14 and len([Cancel Reason])>0"}>} [Non Accepted Sales])

You always have to put the field={} in set analysis and then the set that you want to filter within {} and if the search is dynamci it should always begin with a equal sign {"= expression "}.

Regards.

[tmumaw]

I'm looking for cancel reason code to be equal to anything but '14' or a space, because a space is a good sale.

[pover]

Change the second expression to

sum({$<[Cancel Reason] = {"=[Cancel Reason] <> 14 and len([Cancel Reason])>0"}>} [Non Accepted Sales])

The first expression should still remove the 14's since in set analysis the -= excludes values like the <> in a search expression. What I don't know about the first expression is how it does the intersection of the removing the value 14 and the null or empty Cancel Reasons.

Regards.