Local Member Divided by Local Member

[Former Member]

Hi All,

I have a scenario, where I need to find % Mix yield on YTD values . The formula is need to use is YTD / Total  where both YTD sales and total are local members (highlighed in yellow in below screenshot). How can I achieve this , and make sure the % yield is calculated correctly for the next combination

[Former Member]

HI Vijay,

It can be done by writing formula like EPMMEMER(000)/EPMMEMER(001)

Where 000 is no seq of YTD and 001 is no sequence of Total

PLease let me know if you are still facing issue.

Thanks

Ashish Gupta