Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ex.
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 )
Thanks!!!!!
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
if use sum({<flag_StartEnd={1}>} sales ) on table's expression, all other days show 0 value,correct?
Example
yes! Thanks
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 ?