topic Re: Seemingly ok formula returning blank (i.e. no values) in App Development

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

cgT — Wed, 26 Apr 2023 13:49:20 GMT

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

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

edwin — Wed, 26 Apr 2023 14:02:14 GMT

you need to enclose the values in brackets

{<Transactiondate={...}>}

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

anat — Wed, 26 Apr 2023 14:07:54 GMT

Week calculation should be in curly brackets covered by double quotes