Forum Discussion

otmaneoirda's avatar
otmaneoirda
New Contributor
2 months ago

Member expansion on the "Remove" Function Alternative

Hello Community, I'm writing a rule to copy data from one scenario to another using api.data.calculate. However, I would like to exclude some accounts from being copied. Something like the follow...
Finance
markolainio's avatar
markolainio
New Contributor II
30 days ago

One option is also you can use the RemoveMembers() filter in your api.Data.Calculate:

api.Data.Calculate("V#YTD:S#ACTUAL = RemoveZeros(RemoveMembers(V#YTD:S#ACTUAL_TEST, A#Accounts1ToBeRemoved.Base , A#Accounts2ToBeRemoved.Base))", "A#Root.Base")