Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a variable "Vandaag" which is defined as
concat(Text(year(Now() )) & if(len(text( num(month( now()))))= 1,'0'&text( num(month( now()))) ,text( num(month( now())))) &if(len(text( num(day( now()))))= 1,'0'&text( num(day( now()))) ,text( num(day( now())))) )
and it results in a date like number 20190212
I want to use it in this statement, which works if I just write the number:
=Sum({$<Begindatum={"<20190212"}>}Werktijdfactor_Week) (Note that "Begindatum" is a similar number)
But when I use the Variable
=Sum({$<Begindatum={"<$(Vandaag)"}>}Werktijdfactor_Week) or
=Sum({$<Begindatum={"<$(=Vandaag)"}>}Werktijdfactor_Week) or
=Sum({$<Begindatum={"<$(#Vandaag)"}>}Werktijdfactor_Week)
it doesn't work
Does anyone have a suggestion?
Hi Hagemann,
Please try to use below expression, it works in my desktop sample:
=Sum({$<Begindatum={"<$(=$(Vandaag))"}>}Werktijdfactor_Week)
Thanks.
Aiolos Zhao
try this
=Sum({$<Begindatum={"<$(=$(Vandaag))"}>}Werktijdfactor_Week)
if this doesn't work please put a equal to(=) in your variable defination and then simply use
=Sum({$<Begindatum={"<$(Vandaag)"}>}Werktijdfactor_Week)
Hi Hagemann,
Please try to use below expression, it works in my desktop sample:
=Sum({$<Begindatum={"<$(=$(Vandaag))"}>}Werktijdfactor_Week)
Thanks.
Aiolos Zhao
I think your problem is caused from the number-string which you have created in the variable and which could be easier created with something like:
Vandaag:
= num#(date(today(), 'YYYYMMDD'), '######')
and then you might use:
Sum({$<Begindatum={"<$(Vandaag)"}>}Werktijdfactor_Week)
or if there is no further use for the variable you could use the logic directly within the set analysis like:
Sum({$<Begindatum={"<$(=num#(date(today(), 'YYYYMMDD'), '######'))"}>}Werktijdfactor_Week)
- Marcus