Need help urgently, please

[tracycrown]

Dear QV Experts

Can you help me urgently to create 3 columns next to Plan in the report :

Column 1 : Actual minus Plan ;

Column 2 : Actual minus Outlook &

Column 3 : Plan minus Outlook

Thank you very much, Tracy [:(]

[deepakk]

If you can provide the excel sheets then I can give it a try..........

[tracycrown]

Dear Deepak

Attach excel worksheets per your request, please help me urgently.

Thank you very much, Tracy

[deepakk]

HI I have done it for Student , You can try it out for the rest.

[tracycrown]

Dear Mr Deepak

Well done, you have done a good job, I really appreciate your kind effort and quick response.

Please advise how to modify the script so that it shows only 1 column (Actual minus Plan) instead 3 when users select say Actual & Plan in F2. ie. Auto hide (Actual minus Outlook) and (Plan minus Outlook). I wonder can that be done ?.

Thank you very much, Tracy

[deepakk]

Just click on the Actual minus PLan others will not be shown..!!

[tracycrown]

Dear Mr Deepak

Maybe I did not explain clearly what I really need.

Assuming that we allow users to select either Actual, Plan or Outlook in F2 (ie. excluding Actual-Plan, Actual-Outlook & Plan-Outlook). When users select Actual & Plan, the report will show Atual, Plan and Actual-Plan etc.

Thank you so much, Tracy

[tracycrown]

Dear Mr. Deepak

I have not heard from you since Apr 5, 2010, kindly advise what is the outcome now base on following conditions :

I would like F2 to show only Actual, Plan, Outlook and Variance (computed below)

If F2 = 'Actual' and F2 = 'Plan' then Variance = Actual - Plan

if F2 = 'Actual' and F2 = 'Outlook' then Variance = Actual - Outlook

if F2 = 'Plan' and F2 = 'Outlook' then Variance = Plan - Outlook

Thank you so much, Tracy