Hello guys…
I have a report that runs once a month, summarizes each day of the month and saves the records in a table.
The report is based on the “VARIABLES” table. I have 31 records, one for each day of the month.
I want to write in a “RESUMEN” table where I keep a record for each day of the month, I have other tables where I have many records for each day …
but the problem is in the JSON file …
but this is wrong, [DATE] is in the RESUMEN table, the same as [SUCURSAL], you can see it in the image I send with the JSON file …
If I put the same formula that is in the JSON in app formula for column [EFECTIVO] it works fine ! i send picture…
It does not give error but the result is incorrect, it says zeros for [EFECTIVO] and I am sure it is wrong … I think [SUCURSAL] is BLANK and that is why it does not find records to add. I think the above because in gsheet he wrote the correct value for [SUCURSAL]
WHY DOES NOT RECOGNIZE THE FIELDS OF THE SAME TABLE?
THX FOR YOU HELP !
If you are working with Slices, please check if your “missing” column is in that slice.
User | Count |
---|---|
39 | |
29 | |
23 | |
23 | |
13 |