Workflow & Reports

[Efren]

I am working on a “report” to obtain some statistics of the daily sales … (that is why I do not incorporate these formulas as virtual fields, they are of occasional use, only for the report)

As it is a Report, there are all the sales records of all the stores …

I read the catalog of articles and a table of outputs all the sales of that store …

IN BOTH TABLES I HAVE A SAME FIELD [CORREO]

<< Start: Select (CATALOG [CAT KEY], TRUE) >>
<< [ARTICLE ID] >>

<< SUM (SELECT (OUTPUTS [CTD], AND ([ARTICLE] = [ARTICLE ID], [MAIL] = [_THISROW]. [MAIL], [CTD]> 0, [MONTH] = 6))) >>

<< endIf >>

But it does not run and it gives an error …

Expression ‘SUM ( SELECT( SALIDAS[CTD], AND ([ARTICULO] = [ARTICULO ID] , [CORREO] = [_THISROW].[CORREO] ,[CTD] > 0, [MES] = 6) ) )’ is invalid due to: Error in expression ‘[_THISUSER].[CORREO]’ : Unable to find column ‘CORREO’."

BUT THAT FIELD [MAIL] EXISTS EVEN IN THE TWO TABLES !!! AND IT IS INDISPENSABLE BECAUSE IF I REMOVE THAT CONDITION, READ THE ARTICLE SALES IN ALL THE STORES, ALSO READ IN ALL THE STORES IF I LEAVE [CORREO] = [CORREO!

THIS FORMULA WORK FINE AS VIRTUAL FIELD, BUT NOT IN REPORT!!

PLEASE HELP ME !!!
Captura%20de%20pantalla%20(97)|690x387

] !!!