AddColumns appears to be causing an issue with Filter for me. It's causing filter to omit some or all records that meet the filter criteria. I've triple checked everything. Below is the simplest example of scenario I've been using.
If I remove the addcolumns, the items display. If I change the sum calculation to a simple string like "xxx", the issue persists.
ClearCollect(
col_prf_print,
Filter(
AddColumns(
'Expense Items',
"static_sum",
(item_price * item_quantity) + item_shipping
),
header.'Unbound Header' = gbl_selectedDocHeader.'Unbound Header',
item_status in [
doc_status_choices.Approved,
doc_status_choices.Purchased
]
)
);
Is anyone else experiencing this issue?
