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