If condition in Set analysis

[#1]

Hi Experts,

As I trying the yesterday sales in a text box, so, I tried like Sum({<DATE1= {'$(=Date(today()-1))'}>} [Sales]), which is working fine.

But I have no transaction of sales on Saturday and Sunday, the same expression shows zero as there is no transactions, so I tried

=If(Today()='Mon',Num(Sum({<DATE1= {'$(=Date(today()-3))'}>} [Sales]),'# ##0'), Num(Sum({<DATE1= {'$(=Date(today()-1))'}>} [Sales]),'# ##0')), but the expression shows no results.

Could you please suggest where I went wrong.

Regards

[#2 · Accepted solution]

if(Weekday(Today())='Mon'

[lironbaram]

you need to change it to

=If(weekday(Today())=6,Num(Sum({<DATE1= {'$(=Date(today()-3))'}>} [Sales]),'# ##0'), Num(Sum({<DATE1= {'$(=Date(today()-1))'}>} [Sales]),'# ##0'))

[sujeetsingh]

You can use If only to handle all no need to set analysis

[#5]

Thanks Experts it works ...!