Member formula not working in Hybrid BSO
Member formula working well in traditional BSO, but not working in Hybrid BSO.
We have a pretty simple member formula for an account member, which works without issues with traditional BSO, but when replicating the same in Hybrid BSO it doesn't work. The formula is as simple as below:
The weird thing is that the formula only shows results for Jan, and not showing results for Feb~Dec. Also, the formula only shows results for a certain number of rows(e.g. if I have 20 rows with different sparse member combinations, it only shows results for a few of the rows and the rest of rows has no results). It would be expected that the formula should show the correct results for Jan~Dec with any combinations as it's dynamic calc. This makes no sense and I cannot think of a reason why it's not working.