LinkedIn
Twitter
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
Yes Aleksi, i red all that articuleโฆ
I was wrong to write it but in the Google Docs it is correct and it says well, I do not think it is because of the error โฆ
Any other suggestions ?
or will I have to change all fields with the same name in the tables ???
Now the second part, update the calculated statistical values in the table โฆ
that report calculates the sales of the current month, the previous month and the month of the previous year, for each article of each store โฆ (I send you a screen of the report with the values)
I have read several articles (and othersโฆ)
in this article it says textual โฆ
โUpdate records
You can use a Report to update records. For example, you can scan all open maintenance requests, and assign the Status column the value โHighโ, if the request has been open for more than 48 hours.โ
Do you have any examples of how to do this?
https://help.appsheet.com/articles/1980023-updating-records-in-a-table "
The report that ready but how to update this data in the table ???
Thanks for your helpโฆ
