Nested if statements and Set Analysis

[#1]

Hi Everyone,

I am nesting some if statements and would like some assistance with the following expression. The if WeekDay 'Tue' is working, but if I add the first line to the expression it stops working. Can someone tell me why. I am attaching the file and if you open the expression for Last Week you will see this expression.

if (WeekDay([vToday])='Mon',(Sum({$<DaysFilled.Date = {'$(=vToday)'} >} DaysFilled.Days)-Sum({$<DaysFilled.Date = {'$(=vSevenDayAgo)'} >}DaysFilled.Days)))

    or if (WeekDay([vToday])='Tue',(Sum({$<DaysFilled.Date = {'$(=vOneDayAgo)'} >} DaysFilled.Days)-Sum({$<DaysFilled.Date = {'$(=vEightDayAgo)'} >}DaysFilled.Days)))

[MayilVahanan · Accepted solution]

HI

Try like this

if (WeekDay([vToday])='Mon',(Sum({$<DaysFilled.Date = {'$(=vToday)'} >} DaysFilled.Days)-Sum({$<DaysFilled.Date = {'$(=vSevenDayAgo)'} >}DaysFilled.Days)),

     if (WeekDay([vToday])='Tue',(Sum({$<DaysFilled.Date = {'$(=vOneDayAgo)'} >} DaysFilled.Days)-Sum({$<DaysFilled.Date = {'$(=vEightDayAgo)'} >}DaysFilled.Days))))

Hope it helps

[#3]

Thank you!