BSO member formula not working properly while ASO is working perfectly fine
In my Account dimension, I have four base members in which I would like to conduct the proper allocation.
For example, in my account titled 'Total Non-Reimbursable Positions', I would like to take the total positions (for example purposes, let's say 65,000) which can be allocated from the following entities:
Entity A - 30,000
Entity B - 12,000
Entity C - 8,000
Entity D - 5,000
Entity E - 5,500
Entity F - 4,500
and deduct them from the total Reimbursable (ex: 5,000), broken out as:
Ent. A - 1,500
Ent B - 1,000
Ent C - 800
Ent D - 700
Ent E - 600
Ent F - 400
My BSO formula is written as: