Calculation on dimension

[#1]

Dear Experts,

Please check on the attached files and help us how to create the calculation for SALES vs FORCAST. We tried "  =IF([TYPE]='SALES',SUM([S_LBS]),IF([TYPE]='FORECAST',SUM([F_LBS]),SUM([SF_LBS]+[S_LBS]))) "  and it did not work.

Basically we need to know if sucha calculation is doable or not?

Thanks,

Nima

[kaushiknsolanki]

Hi,

   Can you please functionaly say what you are trying to do ..?

Regards,

Kaushik Solanki

[#3]

Hi ,

Thanks for replying.

Make it simple, let's say if we want to add SALES & FORCAST like (SALES+FORCAST)  OR  (SALES - FORCAST) or any other calculation between 2 dim.

Thanks,

Nima

[nagaiank · Accepted solution]

Are you looking for a solution similar to what is in the attached qvw file?

[#5]

Thanks Krishnamoorty,

You save my life

Nima,