formula issue

[samuel_brierley]

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.

[jagan · Accepted solution]

Hi,

Try this.

sum({$< Date = {'<=$(=Today())'}>} [Total Hours])

Regards,

Jagan.

[Sokkorn]

Hi,

This one

Sum({$<Date = {"<=$(=Date(Today(),'dd-MM-yyyy'))"}>} [Total Hours])

Note: You need format Today() base on your Date field.

Regards,

Sokkorn

[samuel_brierley]

thank you

[#5]

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

[khadeer]

Hi Samuel,

Use this

sum({$<Date={"$(=Today())"}>}[Total Hours])

Regards,

Khadeer