Could someone please help What is the calculation to show Week To Date sales value in a list column
Do you want to filter the list as a whole for week to date? Or do you want to show more records than that and just put the value in a column for those records that are in the week to date? The approach is similar for both...
Depending on what you're running over, you're going to need a function that's something like:
[DateField] between _add_days(current_date,1-_day_of_week(current_date,1)) and current_date
Quote from: cognovice on 16 Oct 2015 12:15:54 AM
Could someone please help What is the calculation to show Week To Date sales value in a list column
This is pretty much the same question you already asked in this post (http://www.cognoise.com/index.php/topic,29242.msg94455.html#msg94455). BigChris also gave you a response there although you never replied back to him.
The techniques he offered in this post as well as in your previous post are pretty much the tried and true methods when dealing with a relational source, which we assume you are although you didn't specify. Did you try that and figure it out and now have issues with the differing time frame?
I would suggest you read the Forum Etiquette since your posts seem to be rather lacking in detail. People offer their valuable time to the forum so make the best use of it by providing sufficient detail.
Hi All,
I appreciate all your help. Sorry for not responding quickly. I was a bit tied up with other stuff.