Dear Experts,
I have the following Valid if Condition for a column in Table A
IFS(
[Txn_Type]="Credit", Filter("Txn_Parties", [Control_Receipt] = "Yes"),
[Txn_Type]="Debit", Filter("Txn_Parties", [Control_Payment] = "Yes")
)
which works fine when a record is added with add action from the view. However, if a record is added through bot Add row to Table A from the values of record added in Table B, the same valid if condition is failing.
"Errors": "Error: Perform DataAction 'Add Client/CP Bank Txn to Control Account' failed because Row having key 'SWCNUS24020800337165' in table 'Control_Account_Statement' containing value 'Client' in field 'Txn_Party' failed 'Valid_If' condition",
Will appreciate any help to resolve this issue. @Suvrutt_Gurjar @Steve @LeventK
LinkedIn
Twitter
