Problem with table

Tue, 23 May 2017 09:04:30 GMT

HI,

i would like to cumulate the number of hours in the year based on a calender and moissequentiel, this is the formula:

sum({$<MoisSequentiel = {">$(#=(MoisSequentiel-12))<=$(#=MoisSequentiel)"}>}Heures)

and i integrated the formula ina if for that only the month that can cumulate can show their results:

=if(MoisSequentiel-12>=0 and sum({$<MoisSequentiel=p(MoisSequentiel)>} Heures)<>0 ,

sum({$<MoisSequentiel = {">$(#=(MoisSequentiel-12))<=$(#=MoisSequentiel)"}>}Heures) ,

if(MoisSequentiel-12<=0,0))

the result is:

the result is the number of hours for the month and not the cumulation for the 13 month preceding this month.

thanks for help, i have joined the excel file and the application.

Re: Problem with table

sunny_talwar — Tue, 23 May 2017 11:18:27 GMT

The app contains no data, can you repost the app with the data and chart to take a look at this?