Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone see an error in this formula?
sum({$< Date }<= {$(=Today()))>} [Total Hours])
its supposed to sum the total hour worked up until today.
p.s needs to be done this way as i have forecasted hours too.
Hi,
Try this.
sum({$< Date = {'<=$(=Today())'}>} [Total Hours])
Regards,
Jagan.
Hi,
Try this.
sum({$< Date = {'<=$(=Today())'}>} [Total Hours])
Regards,
Jagan.
Hi,
This one
Sum({$<Date = {"<=$(=Date(Today(),'dd-MM-yyyy'))"}>} [Total Hours])
Note: You need format Today() base on your Date field.
Regards,
Sokkorn
thank you
Hi,
There is a bracket too much after Date.
Moreover, I would write the expression like that (not tested however):
sum({$< Date = {“<= $(=Today()) )”>} [Total Hours])
Fabrice
Hi Samuel,
Use this
sum({$<Date={"$(=Today())"}>}[Total Hours])
Regards,
Khadeer