The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

otmaneoirda's avatar
otmaneoirda
New Contributor
1 year ago
Solved

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
  • MarcusH's avatar
    MarcusH
    1 year ago

    You can remove more than one by separating them with a comma. Eg .Remove(Acc1, Acc2)

markolainio's avatar
markolainio
New Contributor II
1 year 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")