Selective hiding of calculated field

[PA]

I remember finding this via a Google search about a year ago and now cant
find it.
I have a calculated field, obviously the result shows in every row. I only
want to display in selected rows. I remember this is done with flag fields,
but cant seem to get it to work. Help would be appreciated, and sorry for
any repetition.
Paul

 

[JackD]

You can use a text on a flag field (or any other field you like) to
determine what the result of the formula is.

For example if you have a formula in text1 that is [finish]-[start] and you
want it to display for any task where flag1 is set to yes, then change the
formula like this:

iif([flag1], [finish]-[start] ,"")

If flag1 is yes (true) then it will use your formula, if it is false then it
will be blank ("")

-Jack

 

[PA]

That was what I saw in Google - My thanks.

You can use a text on a flag field (or any other field you like) to
determine what the result of the formula is.

For example if you have a formula in text1 that is [finish]-[start] and you
want it to display for any task where flag1 is set to yes, then change the
formula like this:

iif([flag1], [finish]-[start] ,"")

If flag1 is yes (true) then it will use your formula, if it is false then it
will be blank ("")

-Jack

I remember finding this via a Google search about a year ago and now cant
find it.
I have a calculated field, obviously the result shows in every row. I only
want to display in selected rows. I remember this is done with flag fields,
but cant seem to get it to work. Help would be appreciated, and sorry for
any repetition.
Paul