Hello
I had a virtual column which lowered the app sync time , so I decided to post this calculation only in a report generated in xlsx through workflow email.
So in the last column , Iโm trying to calculate the balance , to the row.
However when I use THISROW , it references to the row of the table which generated the workflow , instead of the row of table Stockledger , which im referencing inside the SELECT.
So my question is how to reference the current row inside the filter / select.
You cannot. Youโll need to perform another โfilter / selectโ to get the value.
Hi Steve ,
Thanks for replying.
Im not sure I understand what you mean by another โfilter / selectโ .
The first cell brings up a filtered table. How do I reference the this table row numbers in my expression ?
PS - this expression worked as a VC , on the original table.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |