Calculate the sum of all values present in the current month

[Aspiring_Developer]

Hello All,

I have below data set :-

I want to calculate the sum of nbhours in a KPI that show the value as 96, i.e  Sum of all the values present in current month.

Kindly help.

Thanks in advance

[sunny_talwar · Accepted solution]

Try this

Sum({<INPUT_DATE = {">=$(=Date(MonthStart(Today(1)), 'M/D/YYYY'))<=$(=Date(Floor(MonthEnd(Today(1))), 'M/D/YYYY'))"}>} NB_HOURS)

or this

Sum({<Input_MonthName = {"$(=Date(MonthStart(Today(1)), 'MMM YYYY'))"}>} NB_HOURS)