Syntax Set analysis

[#1]

Hi!

i am struggling with my first line of set analysis

Sum({<[År Vecka]={'year(today()) & week(today()-1)'},

when i hardcode the value 201426 no problem instead of year(today()) & Week(today()-1)

full statement

Sum({<[År Vecka]={'year(today()) & week(today()-1)'},

Land  = {'E-handel SE'},

DepartmentNo = {'1'}>}

Nettobelopp-InkPris)

any help would be greatly appreciated in using functions with set analysis, otherwise i could perhaps go with an if statement.

Best

Brad

[maxgro · Accepted solution]

maybe

sum({$<[År Vecka]={$(=( year(today())&Week(Today())-1 ))} ,

Land  = {'E-handel SE'},

DepartmentNo = {'1'}>}

Nettobelopp-InkPris)

[#3]

what is the condition you need to give for [Ar Vecka]

[its_anandrjs]

Try this way may be

Sum({<[År Vecka]= { '$(=(year(today())&week(today()-1) ))' },

Land  = {'E-handel SE'},

DepartmentNo = {'1'}>}

Nettobelopp-InkPris)

Or

Sum({<[År Vecka]= { '$(=(year(today())& (=week(today()-1)) ))' },

Land  = {'E-handel SE'},

DepartmentNo = {'1'}>}

Nettobelopp-InkPris)