Seemingly ok formula returning blank (i.e. no values)

[cgT]

Hi there,

I'm trying to calculate the Week on Week up/down percentages for two dynamically changing transaction date ranges:

=(sum({<TransactionDate = '>=$(=WeekStart(Today()))<=$(=WeekEnd(Today())))'>} SoldValue)- sum({<TransactionDate = '>=$(=WeekStart(Today()-7))<=$(=date(Today()-7))'>} SoldValue)) 
/
sum({<TransactionDate = '>=$(=WeekStart(Today()))<=$(=WeekEnd(Today())))'>} SoldValue)

However, when I run it, it returns no value. Not '0' but blank.

Can someone help please?

Thank you 

[edwin · Accepted solution]

you need to enclose the values in brackets

{<Transactiondate={...}>}

[anat · Accepted solution]

Week calculation should be in curly brackets covered by double quotes