Converting BSO Member Formula to ASO Member Formula
I jut converted a BSO cube to ASO cube and there are several member formula that I need to convert. I am trying to convert a BSO formula that has IF and ELSEIF on multiple conditions. I can get the level 0 to work, but I can get the parent level to work. I've tried using CASE/WHEN/THEN statement. Provide below is both the BSO formula and ASO formula I created. Any help would be greatly appreciated.
BSO Formula:
Diluted Outstanding Shares: (This is the Account that has the formula) It is using the Period Dimension and Account Dimension.
IF(