Need Help??

[paulwalker]

Hi All,

I have report i want show previous date.. by default today()-1..

Actually i am using my Expression =Sum({$<Date={$(=max(Date)-1)}>}SALES)

I want to show max of the date......

but we sat and sun holiday..

when i am open on Monday this application.. i want to show Friday data...

Please anyone can help me..???

EX:

ID,  Date,  Sales

200,02/Feb/2015,250

300,03/Feb/2015,235

400,04/Feb/2015,190

500,05/Feb/2015,200

600, 06/Feb/2015, 200

700, 09/Feb/2015, 200

Here max date 09/Feb/2015, i have written max(date)-1,  it will written 08/Feb/2015 data...

i don't want to display 8th data, i want show 6th,Feb data

Thanks in Advance.................

[jagan · Accepted solution]

Hi,

Try this

=Sum({$<Date={'$(=FirstWorkDate(Date(max(Date)-1), 1))'}>}SALES)

Hope this helps you.

Regards,

jagan.

[sunny_talwar]

Update: App Attached

Does this serve your purpose?

Expression: =If(WeekDay(Max(Date)-1) = 'Sun', Sum({$<Date={'$(vMax-3Date)'}>}Sales), Sum({$<Date={'$(vMax-1Date)'}>}Sales))

Where vMax-3Date =Date(max(Date)-3) and vMax-1Date = Date(max(Date)-1)

Best,

S

[paulwalker]

Hi jagan,

if i am using max(date)-1 it's perfect all right,

Friday=Thursday data

Thursday=Wednesday data

Wednesday=Tuesday data

Tuesday=Monday data

But here Monday=i want to show Friday' s data (Because Saturday and Sunday week-off)

By default max(date)-1,  suppose maximum date Monday i want to show Friday' s data

Friday=Thursday data

Thursday=Wednesday data

Wednesday=Tuesday data

Tuesday=Monday Data

[jagan]

Hi,

Try this, this is working for me as expected

=Sum({$<Date={'$(=FirstWorkDate(max(date)+ 1, 1))'}>}SALES)

For Monday this will give Friday.

Regards,

Jagan