Sum if / set analysis

[#1]

Not sure if this is correct. Could someone look at it and let me know?

(the underlining idea is: I've tried to convert but o a set analysis with no luck becasue of the InYearToDate function)

tks!

Sum (if (ACTUALCLOSE<= ReportToDateLastYear and ACTUALCLOSE>=ReportFromDateLastYear and InYearToDate (DATEFROM, yearend(ReportDate,0,8), -1, 😎 AND OPPORTUNITY.STATUS='Closed - Won', ACTUALAMOUNT))

[#2]

Your expression by syntax is right. Better way from memory prespective is to have InYearToDate inside script and use set analysis.

Regards,

Kiran.

[#3]

does this mean i can use the "<=" operator in the expression without having to use it in a set analysis?

[#4 · Accepted solution]

Yes, <= can be used in if condition or set analysis. But if condition consumes more memory compared to set. If you can have your expression calculated at the script level, you can directly use that in set anlaysis.

Let me know you face any problem with the expression.

Regards,

Kiran.