Expression

[mohan2391]

Hi,

Can you change the following expression so that performance should be good and result should be same.

SUM(IF(Guidance_Method_for_APT='MBG',[Net Revenue for Guidance],IF(Guidance_Method_for_APT='DBG',[DBG Net Revenue for Guidance])))

  /

  SUM(IF(Guidance_Method_for_APT='MBG',[Revenue at Typical],IF(Guidance_Method_for_APT='DBG',[DBG Revenue at Typical]))

  )

Thank You

[its_anandrjs · Accepted solution]

Try this with complete statement with set analysis.

=(Sum({<Guidance_Method_for_APT={'MBG'}>} [Net Revenue for Guidance]) + Sum({<Guidance_Method_for_APT={'DBG'}>} [DBG Net Revenue for Guidance]))

  /

  (sum({<Guidance_Method_for_APT={'MBG'}>} [Revenue at Typical] ) + Sum({<Guidance_Method_for_APT={'DBG'}>} [DBG Revenue at Typical]))

Regards

Anand

[Anonymous]

You can apply set analysis in this as following:

(Sum({<Guidance_Method_for_APT={'MBG'}>}[Net Revenue for Guidance])+

sum({<Guidance_Method_for_APT={'DBG'}>}[DBG Net Revenue for Guidance]))

/

(sum({<Guidance_Method_for_APT={'MBG'}>}[Revenue at Typical]+

sum({<Guidance_Method_for_APT={'DBG'}>}[DBG Revenue at Typical]))

Thanks,