Error is Expression

[helen_pip]

Hello,

I have written an expression which is unfortunately returning a 0 value, however I know I am expecting a higher value than 0

Could someone kindly take a look at the syntax and let me know if I have put in too many brackets, or not enough commas etc

Any help would be greatly appreciated

SUM({$<FactDateNum =

{">=$(=date(makeweekdate(year(now()),week(now()))))<=$(=(date(makeweekdate(year(now()),week(now()))+6)))"}>}

QuarterlyBreaches_Attendance_ID)

[MK_QSL]

What is the format of FactDateNum ?

[PrashantSangle]

Hi,

Check your expression in text object

=date(makeweekdate(year(now()),week(now())))

and

=(date(makeweekdate(year(now()),week(now()))+6))

Looks like you have bracket issue in second expression

Regards

[MayilVahanan]

Hi

Hope that FactDateNum contains the date in number format.

Try like this

SUM({$<FactDateNum =

{">=$(=Floor(date(makeweekdate(year(now()),week(now()) ))))<=$(=Floor(date(makeweekdate(year(now()),week(now()))+6)))"}>}

QuarterlyBreaches_Attendance_ID)

Edit: Instead of Now() , please use Today() ..