Template Expression: Virtual Column

[Sarah_Keown]

Hi,

I have a virtual column value that calculates the total number of queries on the app.

When I put it into an app view I get singular values like below.

However, when I try and put totals within the reports it repeats itself for the number of records, see below.

Here is the expression Im using to pull it in.

[Rafael_ANEIC-PY · Accepted solution]

Hello @Sarah_Keown , given your start expression, I believe that’s his intended behaviour, Accounts[Order No] returns all the values of the [Order No] column in the “Accounts” table, if you would like it to return a single value, your Start expression should return the key of the row you’re interested in.

Or if that’s the case then you don’t need a start expression at all, if that virtual column belongs to the table you’re running the workflow from, then using just <<[Procurement]>> might be what you’re looking for.

[Sarah_Keown]

Great, thank you I’ll try it out

[Sarah_Keown]

It seems as a standalone value it doesn’t work, I received this editor error

[Sarah_Keown]

The Report is running from the table that value belongs to also

[Rafael_ANEIC-PY]

Is <<[Procurement]>> outside of any Start expressions that could change from where appsheet evaluates the expression?

[Sarah_Keown]

I used a filter expression to find the value based on the key as you mentioned above and it worked well, thank you