topic Re: Set Analysis with nested IF in App Development

Set Analysis with nested IF

pete_bolin — Tue, 16 Mar 2021 17:42:27 GMT

Hi everyone, looking for a little help with set analysis. Any help would be greatly appreciated. Thanks so much!

I'm trying to sum sales for each day of the workweek (mon - fri). So for each day, I want to sum the sales for that day and place it in a column. So in this example, the next column would be the 17th, 18th, etc for the week.

Here is my formula which is not working.

Sum({$<[SALE_DATE] = {$(=IF(weekday(today()))=2)}>} SALES_COUNT)

Re: Set Analysis with nested IF

eliko_il — Tue, 16 Mar 2021 17:54:33 GMT

Hi,

In this case you don't need to use set analysis.

Choose pivot chart and add the day as a column, which make the day to appears horizontal in the chart.

Final ,just use simple sum expression without set analysis.

Re: Set Analysis with nested IF

pete_bolin — Tue, 16 Mar 2021 18:24:33 GMT

Thank you for the reply. I did think of that, but I need to email this out on a daily basis via NPrinting. Pivot tables don't look good in a report and users complain. So, I try to keep it to a tables. But I may have no option in this case. Thanks again! Cheers!