Custom Field Question

[Dudley Wright]

Hello, I am new to the group, and hope someone can help.
I am customizing the cost table, adding a currency field to calculate
10% of the Fixed Cost field and another to subtract the previous two.
I know I could do this with one field, calculating 90% of fixed cost,
but the intermediate field is of interest.
When I add a calculated field, values show up for all tasks, not the
desired results. How can I hide the calculation for selected tasks.
I hope I explained this properly.
Thanks
Dudley

 

[John Beamish]

Formulas apply to the column and not to the cell or task. In other words,
it doesn't appear to be possible.

However ... if you used a flag field and set that to Yes/No depending on
whether or not you wanted the cost to appear then you could use something
like this:

IIf(Flag1=Yes,[Fixed Cost]*0.1,0)

JLB, PMP

Hello, I am new to the group, and hope someone can help.
I am customizing the cost table, adding a currency field to calculate
10% of the Fixed Cost field and another to subtract the previous two.
I know I could do this with one field, calculating 90% of fixed cost,
but the intermediate field is of interest.
When I add a calculated field, values show up for all tasks, not the
desired results. How can I hide the calculation for selected tasks.
I hope I explained this properly.
Thanks
Dudley

--

 

[Dudley Wright]

That is precisely what I need to accomplish.
Thank you.

Formulas apply to the column and not to the cell or task. In other words,
it doesn't appear to be possible.

However ... if you used a flag field and set that to Yes/No depending on
whether or not you wanted the cost to appear then you could use something
like this:

IIf(Flag1=Yes,[Fixed Cost]*0.1,0)

JLB, PMP

Hello, I am new to the group, and hope someone can help.
I am customizing the cost table, adding a currency field to calculate
10% of the Fixed Cost field and another to subtract the previous two.
I know I could do this with one field, calculating 90% of fixed cost,
but the intermediate field is of interest.
When I add a calculated field, values show up for all tasks, not the
desired results. How can I hide the calculation for selected tasks.
I hope I explained this properly.
Thanks
Dudley

--

 

[JackD]

I have some more information about calculated fields here.

http://masamiki.com/project/customfieldFAQ.htm

-Jack

That is precisely what I need to accomplish.
Thank you.

John Beamish <jlbeamishAThotmailDOTcom> wrote in message

Formulas apply to the column and not to the cell or task. In other words,
it doesn't appear to be possible.

However ... if you used a flag field and set that to Yes/No depending on
whether or not you wanted the cost to appear then you could use something
like this:

IIf(Flag1=Yes,[Fixed Cost]*0.1,0)

JLB, PMP

Hello, I am new to the group, and hope someone can help.
I am customizing the cost table, adding a currency field to calculate
10% of the Fixed Cost field and another to subtract the previous two.
I know I could do this with one field, calculating 90% of fixed cost,
but the intermediate field is of interest.
When I add a calculated field, values show up for all tasks, not the
desired results. How can I hide the calculation for selected tasks.
I hope I explained this properly.
Thanks
Dudley

--