Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
Sum({<ind_Date ={"$(=varToday)"}>}ind_OnHandValue)
Your ind_Date and variable date format should match
Try this:
=Sum({<ind_Date = {"=Date(ind_Date, 'DD/MM/YYYY') = Date(varToday, 'DD/MM/YYYY')"}>} ind_OnHandValue))
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)