Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey there,
I'm pretty stumped - I've checked to make sure that the date formatting all lines up and the set analysis checks out (to my untrained eye).
Could you please help me fix the following set analysis? It gives me the error: 'Error in set modifier ad hoc element list: ',' or ')' expected in formula'.
Thank you,🙂
Erika
Set Analysis
=count({$<Fund_Date={$(vYestDate)}>}distinct Fund_AppID)&' apps' &Chr(10)
& num(sum({$<Fund_Date={$(vYestDate)}>}Fund_AmountText),'$###,##0')
Formats for variables
date(Date#(makedate(year(Fund_DateTime),month(Fund_DateTime),day(Fund_DateTime)),'yyyy/mm/dd')) as Fund_Date
Let vYestDate = if(WeekDay(Today(0)) = 'Mon', Date(Today(0) - 3),if(WeekDay(Today(0)) = 'Sun', Date(Today(0) - 2), Date(Today(0) - 1)));
change your expression to below
=count({$<Fund_Date={'$(vYestDate)'}>}distinct Fund_AppID)&' apps' &Chr(10)
& num(sum({$<Fund_Date={'$(vYestDate)'}>}Fund_AmountText),'$###,##0')
change your expression to below
=count({$<Fund_Date={'$(vYestDate)'}>}distinct Fund_AppID)&' apps' &Chr(10)
& num(sum({$<Fund_Date={'$(vYestDate)'}>}Fund_AmountText),'$###,##0')
Thank you! 😊
👍