Forum Discussion

tcook's avatar
tcook
New Contributor
6 months ago
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....
Finance
pranav46's avatar
pranav46
Contributor II
6 months ago
api.Data.Calculate("U4#Target = RemoveZeros(U4#Source*-1)","A#IncomeStatement.Base,,,,,,U3#UserDefined.Base.Where(Text1 = YourTextValue)")

Can you try this?