Set Analysis working in a strange way

[#1]

Hi,

I am now working on an AP report and trying to filter the pastdue 1-30 days amount by using set analysis.

I have used this statement to load the field "Past_Due_Aging" for easier reference for traffic light guage in the script:

     dual(Past_Due_Aging,match(Past_Due_Aging,'<=30','31-60','61-90','90-120','Over 120')) as "Past_Due_Aging"

However, After I used the dual function, one of the expression that using set analysis is working in a strange way.

I used

=Sum({<Past_Due_Aging ={'<=30'},Past_Due={'Yes'}>}Open_Amt * ExRate)

as expression to show the pastdue 1-30 days amount.

However, the data shown in this expression is actually equal to

=Sum({<Past_Due={'Yes'}>}Open_Amt * ExRate) instead.

And I do not understand why '<=30' value cannot be filtered.

But for the 'Current amount', I'm using the expression ,

=Sum({<Past_Due_Aging ={'<=30'},Past_Due={'No'}>}Open_Amt * ExRate)

and it is actually working properly.

I have struggled in this problem for long. Can anyone suggest the reason of this?

But Sorry that I cant provide sample file for this problem.

Regards,

CK