Monthend and Monthstart- QS

[s_santalucia]

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

[s_santalucia]

Ex.

[francescoreggia]

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 )

[s_santalucia]

Thanks!!!!! 

[s_santalucia]

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

[francescoreggia]

if use sum({<flag_StartEnd={1}>} sales )  on table's expression,  all other days show 0 value,correct?

[francescoreggia]

Example

[s_santalucia]

yes! Thanks

[consultant_bi]

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 ?