
Partner - Creator
2018-07-13
04:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Monthend and Monthstart- QS
Hello
in my analysis
I want to calculate the sales on the first day of the month (01/07/2018) and the last day of the month (31/07/2018), of all the months.
can u help me?
Thanks
2,077 Views
8 Replies

Partner - Creator
2018-07-13
04:23 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ex.
1,991 Views


Partner - Contributor III
2018-07-13
04:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Stefania,
in script create a new dummy field like
if( Date = MonthStart(Date) or Date = MonthEnd(Date),1,0 ) as flag_StartEnd,
ecc...
then in front end use
sum({<flag_StartEnd={1}>} sales )

Partner - Creator
2018-07-13
04:42 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks!!!!!
1,991 Views

Partner - Creator
2018-07-13
04:59 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
and to add sales on the first day of the month and the last day? I created a table as in the picture I attached
1,991 Views


Partner - Contributor III
2018-07-13
05:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if use sum({<flag_StartEnd={1}>} sales ) on table's expression, all other days show 0 value,correct?


Partner - Contributor III
2018-07-13
05:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Example

Partner - Creator
2018-07-13
05:29 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yes! Thanks
1,991 Views


Creator
2018-07-13
05:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you wanna store on a table the sum of sales by month on the last day and the first day of the next month ?
1,991 Views
