Template Expression: Virtual Column

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.
image

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.

image

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.

2 Likes

Great, thank you I’ll try it out :slight_smile:

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

1 Like

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

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

1 Like

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

2 Likes