Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am currently using a variable field to compare sales for a day.
Sum({< Inv_Date = {'$(=vDateCompare1)'}>}
How would I be able to change that value so that it includes for the full week.
All invoices from vDateCompare1 field up to vDateCompare1 + 6
Thanks
Sum({< Inv_Date = {'$(=vDateCompare1)'}>} Inv_Invoiced)
Sorry missed the end off the formula
Hi Allan,
You have to create two variables, vStartWeekDate and vEndWeekDate
Then you have to write the set analysis expression with less than(<) and greater than(>) symbols.
Regards,
Rajesh R. S.
Hi Allan,
What's the value of your variable vDateCompare1?
And what exactly its use?
It can be any date entered. e.g. 14/02/2017
May be this:
Sum({< Inv_Date = {">=$(=vDateCompare1)<=$(=vDateCompare1+6)"}>FIELD}
I was thinking about a second variable as it did not like me adding 6.
I've managed to get it to work however with this. I'm not sure how messy it is.
sum((IF(inweek(Inv_Date, vDateCompare1, 0), 1, 0))*Inv_Invoiced)
Thank you for taking the time to reply.
Hi Allan,
You clearly have a dimension of [Date]. Why do not you want to use to filter sheet date with any manually selection of dates? Another option, make the selection of what you need, make a bookmark and in the expression Set Analisys make a link to this bookmark.
Regards,
Andrey
Hi Andrey,
Thank you for taking the time to reply. To clarify I want to be able to obtain a full week's sales so that they can be compared to a different week's sales without the hassle of selecting each date manually which is time consuming for the reps.
The InWeek function has allowed me to compare 2 different weeks by entering just one date in the variable field.
This then shows the total sales for each customer that week in a column, puts the previous week in the next table column and calculates the difference in the third so we can see if the sales have increased/decreased week on week.
Allan
You want to see the result of weekly or how long the scanning window in a week? Today, February 24, 2017, Friday.
1.Сomparison depth - Sunday this week (19.02.2017 or a another day?)?
2.Comparison depth - Friday of last week(17.02.2017)?
Regards,
Andrey