Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Friends,
why is not this measure working?
Sum ({<VENCTO = {'<$ (vToday)'}>} ValorVencto)
Field VENCTO = DD/MM/YYYY
Variable = Date(Today(), 'DD/MM/YYYY')
If I put Sum ({<'24/01/2018'= {'$(vToday)'}>} ValorVencto) It works
Sum ({<VENCTO = {'24/01/2018'}>} ValorVencto) It works
I have tried in several ways like:
Sum ({<VENCTO_ANOMESDIA = {'<$(vToday)'}>} ValorVencto)
Field VENCTO = YYYYMMDD
Variable = Date(Today(), 'YYYYMMDD')
Sum ({<VENCTO_NUM = {'<$(vToday)'}>} ValorVencto)
Field VENCTO = 43124
Variable = NUM(Date(Today(), 'YYYYMMDD'))
NONE OF THESE MEASURES WORKED.
What am I doing wrong?
You should definitely use double quotes if you want to use a search:
And also have a look at
So, in total try
Sum( {<VENCTO={"<$(vToday)"}>} ValorVencto )
Have you tried to move the first single quotation mark to steps to the right like this and enclosing the entire search in double quotation marks. You can not have a space between the $ and the ( either:
Sum( {<VENCTO={"<'$(vToday)'"}>} ValorVencto )
Did not work.
Follow the picture.
Have you defined your variable with a leading equal sign or without?
You should definitely use double quotes if you want to use a search:
And also have a look at
So, in total try
Sum( {<VENCTO={"<$(vToday)"}>} ValorVencto )