Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have this expression:
=SUM({<
P_DATE_PRODUCTION = {'<=$(DATE_EXTRACTION)'},
RIGHT(P_DATE_OUVERTURE,2) = {'=RIGHT($(ANNEE_EXTRACTION),2)'}
>}P_MONTANT_PRODUCTION)
When I delete RIGHT(P_DATE_OUVERTURE,2) , the error is taken.
But I can't handle without the condition in red.
Any help please?
Regards.
The LHS of set expressions must be a physical field name, so you cannot use Right(...) there. Options are
RIGHT(P_DATE_OUVERTURE,2) as Derived
and use this field in the set expression
P_DATE_OUVERTURE = {"=$(=RIGHT(P_DATE_OUVERTURE,2) = RIGHT($(ANNEE_EXTRACTION),2)"}
(success will depend on the data structure in your document)
You can create a field in backend with RIGHT(P_DATE_OUVERTURE,2) as XXXXX,
Use this field the expression
=SUM({<
P_DATE_PRODUCTION = {'<=$(DATE_EXTRACTION)'},
XXXXX = {'=RIGHT($(ANNEE_EXTRACTION),2)'}
>}P_MONTANT_PRODUCTION)
Thanks for your answer.
I edited like this:
=SUM({<
P_DATE_PRODUCTION = {'<=$(DATE_EXTRACTION)'},
P_DATE_OUVERTURE = {'=$(RIGHT(P_DATE_OUVERTURE,2)
=RIGHT($(ANNEE_EXTRACTION),2)'}
>}P_MONTANT_PRODUCTION)
The expression is ok.
But when I press the apply button, I find this error: error in set modifier ad hoc element: ; or ') , strange no?
Regards
I tried it before posting my problem.
But the system doesn't accept a field in backend in the place of the attribut.
Regards
If P_DATE_OUVERTURE is a field
Then you can create new field in backend
RIGHT(P_DATE_OUVERTURE,2) as XXXXX,
syntax error bro
can u share qvw or code which you used
Corrected expression
SUM({<
P_DATE_PRODUCTION = {'<=$(DATE_EXTRACTION)'},
P_DATE_OUVERTURE = {'=$(=RIGHT(P_DATE_OUVERTURE, 2)
=RIGHT(ANNEE_EXTRACTION, 2))'}
>} P_MONTANT_PRODUCTION)
Try this may be
=Sum({<P_DATE_PRODUCTION = {"<=$(DATE_EXTRACTION)"}, P_DATE_OUVERTURE = {"=RIGHT(P_DATE_OUVERTURE, 2)
= RIGHT($(ANNEE_EXTRACTION), 2)"}>} P_MONTANT_PRODUCTION)
2 things I changed
1) Remove dollar sign expansion on top of RIGHT function for your P_DATE_OUVERTURE
2) Use double quotes for search string