If you are unable to create a new account, please email support@bspsoftware.com

 

What is the calculation to show Week To Date sales value in a list column

Started by cognovice, 16 Oct 2015 12:15:54 AM

Previous topic - Next topic

cognovice

Could someone please help What is the calculation to show Week To Date sales value in a list column

BigChris

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

Lynn

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. 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.

cognovice

Hi All,
I appreciate all your help.  Sorry for not responding quickly.  I was a bit tied up with other stuff.