Set Analysis

[pkelly]

Hi...

Have the following set analysis expression...

='Due: Overdue: ' & num(Sum({< soo_LatestDate = {"$(<varToday)"}, soo_FamilyCode = {'01', '02'} >} soo_RemainingValue),'£ #,##0;(##,##0)')

I know that I can do this easily with an IF statement but am trying to learn set analysis...

Basically trying to show the value of late sales orders in a text box for product families 1 and 2.

O know for definite that there are some but this expression is returning zero.

varToday is a variable which holds todays date = soo_LatestDate field an date variable are in format DD/MM/YYYY

Any assistance greatly appreciated.

Regards

Paul

[sunny_talwar · Accepted solution]

Lets focus just on the expression, formatting can be done later. Try this may be:

=Sum({< soo_LatestDate = {"<$(varToday)"}, soo_FamilyCode = {'01', '02'} >} soo_RemainingValue)

[Anonymous]

Try this

='Due: Overdue: ' & num(Sum({< soo_LatestDate = {"<$(varToday)"}, soo_FamilyCode = {'01', '02'} >} soo_RemainingValue),'£ #,##0;(##,##0)')

[Clever_Anjos]

"$(<varToday)" should be "<$(=varToday)"

And varToday should be formatted just like soo_LatestDate

[pkelly]

Thanks everyone...