Hello friends
I am making a report where I have several records for the same day, and the report I just want to add all the records of the day giving me a total per day, but โฆ
I send you the report screen,
when I use [_THISROW].[DATE], I get an error!
" Error in expression โ[_THISUSER].[DATE]โ : Unable to find column โDATEโ."
Iโm sure the name of the field is fine! in # 2 it works with the same name !
if I use [KEY].[DATE] I donโt get the sum per day but for the whole table!
It does not take into account that I only want the sum of those who have the same date !!!
Can someone please guide me!!
Thx Bellave, i have write [_THISROW], you can see it in the picture of the google doc, the 2nd columnโฆ
<<SUM( SELECT( CORTE[PREVIO $], AND([FECHA ID] = [_THISROW].[FECHA ID], [UPPER SUC] = [SUCU])) )>>
where you see [THISUSER] is in the 2nd picture, the AppSheet Logโฆ i do not know whyโฆ
Does there exist a column named FECHA ID in the table [_THISROW]
refers to?
Thx Steve I really appreciate your time and your council โฆ
Yes it doesโฆ
even remember that if I use [KEY].[FECHA ID] does not generate error, the report is executed but it adds all the records of the table โฆ
WHY THE REFERENCE TO THE CURRENT RECORD [_THISROW] DOES NOT WORK? says error, because the variable does not exist, but it does exist!
IS NORMAL THAT IN THE LOG, [_THISROW] BE REPLACED WITH [_THISUSER]?
Can you think of another way to achieve the same, add records of the same day to a daily total?
Sorry, my lack of familiarity with report templates confused me. _THISROW isnโt available where youโre trying you use it. If this <<Start>>
block is inside another one, you can use _THISROW-1 instead. See Accessing Columns in Parent and Grandparent Records in Template Start Expressions.
ahh thatโs new!
it is good to know the reason, I fix it while making a virtual variable in the table, keeping there the value to compare โฆ
I will need it later [_thisrow-1]โฆ
Thx, many Thxโฆ
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |