BSO TO ASO Formula conversion
Hi Experts,
I have a BSO cube with the member formula below in QTR1. How do I write this in ASO member Formula? Your help will be much appreciated.
IF(@ISUDA("Account", "Average-Actual"))
IF(@ISUDA("Year", "Hsp_LeapYear"))
("Jan"*31 + "Feb"*29 + "Mar"*31)/(31+29+31);
ELSE
("Jan"*31 + "Feb"*28 + "Mar"*31)/(31+28+31);
ENDIF;
ELSEIF(@ISUDA("Account", "Average-Actual365"))
("Jan"*31 + "Feb"*28 + "Mar"*31)/(31+28+31);
ELSEIF(@ISUDA("Account", "Flow") OR @ISMBR("Account"))
"Jan" + "Feb" + "Mar";
ENDIF;