cumulative sales

[pirotfab]

Hello, I use this formula: sum (sales)

I have three info to search, (1) sales of the day, (2) sales of the month, and (3) salesof the year

fallowing the date, I wish that:

(1): displays the CA of the day (=> ok)

(2): displays the month's sales, cumulative from the 1st day of the month to the selected day

(3): displays the annual sales from 01/01 to the selected month.

Is it possible using the "inmonth" and "inyear" functions or with other types of functions?

thank you in advance for your help

[arjakumar]

Hi Fabien,

Please find the below expressions.

Sales of the day     sum(<${Date={Today()}}>total Sales)

Sales of the month       sum{<${Date={'>=$(=Monthstart(Today()))<=$(vSelectedDate)'}>total Sales}

vSelectedDate need to be passed through inputbox

Sales of Year sum{<${Date={'>=$(=Yearstart(Today()))<=$(=Month($(vSelectedDate)))'}>total Sales}

[pirotfab]

Hi Arja,

This expression does not work

sum{<${Date={'>=$(=Monthstart(Today()))<=$(vSelectedDate)'}>total Sales}

thanks

[arjakumar]

Have you created vSelectedDate variable.

[pirotfab]

Hi,

i find this expression with two variables

=sum({<date={">=$(=vFirstDayMonthDateSelect)"}*{"<=$(vDateSelect)"}>} sales)

=sum({<date={">=$(=vFirstDayYearDateSelect)"}*{"<=$(vDateSelect)"}>} sales)

Thanks

Fabien