Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
The app contains no data, can you repost the app with the data and chart to take a look at this?