Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
lets say i have the attached table, and i want to sum only values when date2 is greater than date1 - marked in yellow
i don't want to use IF statement, instead i would like to do it with Set Analysis, i use the following and it didn't work:
=Sum( {<date1={">$(=MIN(date2))"}>} cost)
what im doing wrong?
Hello,
Try below,
Sum({<Cost = {"=Date2>=Date1"}>}Cost)
Hope this helps.
Thanks,
Ashutosh
Hello,
Try below,
Sum({<Cost = {"=Date2>=Date1"}>}Cost)
Hope this helps.
Thanks,
Ashutosh
hi
working great!
but why the modifier is cost? shouldn't it be date1 vs date2?
We are taking only cost line items where Date2 is greater than Date1