Weekly Group Total and associated YTD total

[Former Member]

Hello,

I need to show current week group total and total year to date of the same group. My columns are Model, Department, Issue. Currently, the report is grouped on Model, Department and Issue with a filter for date. Can this be done? Thank you

[Former Member · Accepted solution]

Hi Carl,

Where would I put that formula? Here is what I am looking for

Current Week Year to Date

Model

Department

Issue 5 25

Thank you,

[Former Member · Accepted solution]

Create a formula field, say {@Current Week Amount} as (basic syntax):

if datepart("ww", {datefield}) = datepart("ww", CurrentDate) then
  formula = {amount}
else
  formula = 0
end if

You can then sum() this, or place it in a detail line, or whatever. It will only have a (non-zero) value when the date field is in the current week.

HTH,

Carl

[Former Member]

Yes. Your date filter has to be from the first of the year. You then need to create a formula that totals on the condition

datepart("ww", {datefield}) = datepart("ww", CurrentDate)

HTH,

Carl