virtual column not showing values in detail view

AppSheet AppSheet Q&A
,
1

I have a few virtual columns in a table that I want to show in detail view. But some are not show value in the view but in test you can see the values.

The formula for these columns are:-

Decimal(Any(Select(InvoiceTriggers[PaymentDue],AND([_Thisrow].[Job]=[Job],[Triggers]="Retainer"))) *
any(select(InvoiceTriggers[PaymentDue],AND([_Thisrow].[Job]=[Job],[_Thisrow].[InvoiceTrigger]=[Row ID]))) *
Any(Select(Quotes[QuoteAmount],[row id]=[_thisrow].[Quote])))

Any(Select(INVOICETRIGGERS[TriggerValue],[_Thisrow].[InvoiceTrigger]=[Row ID]))
2

Columns appear in detail views if those are not blank for that particular record. So a column called say [Suburb] , if it has value for a record 1 then it will appear in the detail view of record 1 but if it has no value ( it is blank) for record 2, then it will not appear in the detail view of record 2.

Other typical points to check are if the columns are included in the slice or view column order etc.