Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem with an expression set analysis, I want this test
dituationdate=(maxyear)-1 '&-12'
-->sum({<SITUATION_PRODUIT={$(=Max(YEAR)-1)&"-12"}>}REAL_TITRES.ENCOURS_TITRES)
It does not work always show the expression in red
So you want to create something like '2016-12' ?
Try
sum({<SITUATION_PRODUIT={"$(=(Max(YEAR)-1) & '-12')"} >} REAL_TITRES.ENCOURS_TITRES)
why do you need dituationdate, but use SITUATION_PRODUIT ?
So you want to create something like '2016-12' ?
Try
sum({<SITUATION_PRODUIT={"$(=(Max(YEAR)-1) & '-12')"} >} REAL_TITRES.ENCOURS_TITRES)
Im not sure if this makes any difference as long as there are no spaces within the search string?!?
I don't trust in the syntax checker
I just tried it:
LOAD * INLINE [
F1
012016
022016
];
--> this works even without quotes:
But as soon as there's a "-" a space or any other "special sign" in the search string you'll need single or double quotes.
So I admit I was wrong...
There should be a difference, since in the OP, the dollar sign expansion stops after -1.
The concatenation thereafter is not a valid syntax.
i used this expression ,But the result is always null
How do the values of field SITUATION_PRODUIT look like?
For example,post a screenshot of a list box.
thank y Stefan , i fixed the problem
thank y Robin i fixed the problem , hank y for yr help