Solved
Utilizing a Where Clause for filtering on a Text Field in an api.Data.Calculate business rule
I am unsuccessfully trying to write an expression to utilize a Text Field as a filter in a business rule: api.Data.Calculate("U4#Target = U4#Source*-1","A#IncomeStatement.Base",,,,,,"U3#UserDefined....
api.Data.Calculate("U4#Target = RemoveZeros(U4#Source*-1)","A#IncomeStatement.Base,,,,,,U3#UserDefined.Base.Where(Text1 = YourTextValue)")Can you try this?
