Sum of Costs in current week in Textbox

[#1]

Hello everyone

I would like to show the sum of my Field "costs" in a textbox. But only of the current week. What is the expression for this?

Thank you very much in advance...

[giakoum]

=Sum({<Week={"$(ThisWeekVariable)"} >} costs)

Assuming that you have a variable holding this week

or you may replace the variable with an expression for this week :

=Sum({<Week={"$(=week(today()))"} >} costs)

[#3]

Hi,

Try something like this

=sum( {$<Week = Week(today()) >} Costs )

[#4]

Ευχαριστώ

But then I get all values from week 40, also in the years before, right?

Best

Jan

[giakoum · Accepted solution]

true so add year in the set expression as well

=Sum({<Week={"$(=week(today()))"}, Year={"$(=Year(today()))"}>} costs)

[#6]

Okay, the value in the textbox is still the total sum of all values. The whole expression is underlined with a red line. something does not fit with the expression yet...

[ashfaq_haseeb]

Try like this

=Sum({<Week={"$(=week(today()))"},Year={"$(=Year(today()))"} >} costs)

Replace fields with your actual fields

Regards

ASHFAQ

[#8]

AWESOME! Thank you very much!

[er_mohit]

Try this

Sum({$<DATE={"<=$(=Date(Max(DATEWeek)-7,'DD-MM-YYYY'))"}>}costs)

Make sure Date format is same as used for Date field.

[ashfaq_haseeb]

Hi,

Can you close this thread by selecting appropriate answers.

Regards

ASHFAQ