set analysis expression

[krishnagutha1294]

Hi all

I am having an expression like below

Sum({<year={2015}>}Sales)/Sum(Profit) + (Sum({<year={2016}>}Sales))/Sum({<Product={Apple}>}profit)

 For 2015 denominator is Sum(Profit) and 2016 Denominator is Sum({<Product={Apple}>}profit)

but if execute above expression both denominator taking Sum({<Product={Apple}>}profit) please can any one resolve above condition.

Thanks in advance

[krishnagutha1294]

Thanks its working For sample.

Actually for my application is not working. As per below logic 

(Round((Count({<"Commodity Group"={'HDD - Hard Disk Drive','SSD - Solid State Drive','Power Supply'}>} actn_part_srl_nr1)/count(BU))*1000000)
+ Round((Count(${<"Commodity Group"={'Memory'}>}[ncnfrmc_cd])/(Count(BU)))*1000000)
+ Round((Count({<"Commodity Group"={'Processor'}>}[ncnfrmc_cd1])/Count(BU))*1000000))

i am getting out put like below

If use filter condition in one of the denominator. The resultant output like below 

(Round((Count({<"Commodity Group"={'HDD - Hard Disk Drive','SSD - Solid State Drive','Power Supply'}>} actn_part_srl_nr1)/count(BU))*1000000)
+ Round((Count(${<"Commodity Group"={'Memory'}>}[ncnfrmc_cd])/(Count({<[Standard Supplier]={'Samsung','Kingston','Micron','SK Hynix'}>}BU)))*1000000)
+ Round((Count({<"Commodity Group"={'Processor'}>}[ncnfrmc_cd1])/Count(BU))*1000000))

Kindly can any one help to resolve the above issue

[sunny_talwar]

What selection did you make? what were you expecting to see after the selection was made?

[krishnagutha1294]

I didn't make any selection just i want to perform that expression with filter condition in denominator.

Pls help me what is the problem with that expression.  

[sunny_talwar]

I am unable to follow your issue.

[krishnagutha1294]

I want to get output like how i am getting the sample.

Pls advice me

[sunny_talwar]

Can you share your qvf file?

[krishnagutha1294]

Working in Hub i am unable to get Qvf File.

In That Expression is any problem is there.

[sunny_talwar]

no idea