Virtual column not showing in report

Hey,
Am hoping this is a simple one:

I have a virtual column that displays fine in the app but appears as empty when I try to use it in a formula expression in a scheduled report. When Iโ€™ve tried to pull that specific value in a lookup() formula it returns 0.00 while the actual value is 62.5 and clearly displayed in the app. Help?

0 9 729
9 REPLIES 9

May I ask what kind of formula are you using with the virtual column?

I tried

<<Lookup("[key]",โ€œtableโ€,โ€œvalueโ€,"[virtual column]")>>
<<any(select([virtual column],[key]=value)>>

This:

<<Lookup("[key]",โ€œtableโ€,โ€œvalueโ€,"[virtual column]")>>

should be:

<<Lookup([_THISROW].[key],โ€œtableโ€,โ€œvalueโ€,"virtual column")>>

Remove the quotes around [key], prefix [key] with [_THISROW]., and remove the square brackets around the virtual columnโ€™s name.

Ok I didnโ€™t explain well: what I wrote was this exactly:

<<lookup(โ€œ1โ€,โ€numbersโ€,โ€keyโ€,โ€Last monthโ€™s rateโ€)>>

where 1 is the value of the key column in the numbers table where I want it to return the value of the column called Last monthโ€™s rate

@Olivia_Bryanne_Zank1 Are you using any security filter with the โ€œNumbersโ€ table?

nope

anyone have an idea why this isnโ€™t working?

I suggest you contact support@appsheet.com directly for help with this.

Steve is correct about submitting a report to support.

When you do that please provide:

  1. Your account id
  2. The app name
  3. The Report name
  4. The name of the virtual field

When the Report is invoked by the scheduler, it runs under the identity of the application owner. As a result, all expressions are evaluated using the identity of the application owner. That is why Aleksi is asking about security filters. Security filters can block access to records that the virtual field expression may attempt to access. In general, you must ensure that the Report will execute correctly when run under the identity of the application owner.

Top Labels in this Space