Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All ,
I have the below expression to calculate the Total YTD Sales for top N Customers but the expression is is returing 0 when the current month sales is Zero.
=Sum(Aggr(If(Rank($(eActualValueYTDRank)) <= $(vHospRank), $(eActualValueYTDRank)),ListHosp_Ranking))
Any insights on the issue is welecome.
Thanks
Kusha
The best I have would be to break apart the expression into smaller chunks putting those into Text boxes to try to figure out which piece is causing the issue, one of my counterparts taught me that trick years ago, but I am still not a very good developer unfortunately! 🙂 Hope this may help if you are still working on it.
The only other place I could point is the Online Help for the different functions you are using to check things there.
Regards,
Brett
The reason could be anything as a start have u checked with the condition If(Rank($(eActualValueYTDRank)) <= $(vHospRank) returns ??