Set Analysis

[pkelly]

Hi all

Trying to get into Set Analysis more and have converted a few IF statements...

=sum(IF(Date(ind_Date, 'DD/MM/YYYY') = Date(varToday, 'DD/MM/YYYY'), ind_OnHandValue))

How would you go about writing the above in Set Analysis?

Thanks in advance for any assistance.

Regards

Paul

[Kushal_Chawda]

Try

Sum({<ind_Date ={"$(=varToday)"}>}ind_OnHandValue)

Your ind_Date and variable date format should match

[sunny_talwar]

Try this:

=Sum({<ind_Date = {"=Date(ind_Date, 'DD/MM/YYYY') = Date(varToday, 'DD/MM/YYYY')"}>} ind_OnHandValue))

[swuehl]

If ind_Date field is formatted as a number and the variable as well, try:

=Sum( {<ind_Date = {$(varToday)} >} ind_OnHandValue)

Basically field ind_Date and your set modifier should be formatted the same.

If ind_Date is formatted as Date DD/MM/YYYY, try:

=Sum( {<ind_Date = {'$(=Date(varToday,'DD/MM/YYYY))'} >} ind_OnHandValue)