Forum Discussion
Solved
Referencing a NULL field - Customized Column
Hi I am trying to reference a null field but I am not getting right. I am trying to display "%" after my calculation. So I have a number column called Budget Cost. I created a Text11 column and h...
- kish27,
Sorry but something doesn't quite make sense. You say you have a custom number column called Budget Cost, but number fields will always have a default value of zero. Are you sure you don't mean your Budget Cost field is a custom Text field?
Project does have a Budget Cost field but it is only applicable to the Project Summary Task.
Assuming your "Budget Cost" field is Text2, the following formula should give what you want:
IIf([Text2]<>"",format([Text2]/186000*100,"#.00") & " %","")
Hope this helps.
John
Hi John
I was going to tag one of your replies as the best response I noticed Dale has done so. I would like tag another response as best response but don't seem to know how to tag this. I was looking for option in the reply I cannot see how this is done. Any idea how this is done.
Rgds
Kish
I was going to tag one of your replies as the best response I noticed Dale has done so. I would like tag another response as best response but don't seem to know how to tag this. I was looking for option in the reply I cannot see how this is done. Any idea how this is done.
Rgds
Kish
Kish --
I untagged one of John's responses. Feel free to task whichever response you believe is the best answer.
I untagged one of John's responses. Feel free to task whichever response you believe is the best answer.
- Hi Dale
It was the same one you tagged. Hence Ire- tag the same response as the best answer from John. I thought each discussion thread could have more than one best response tag which is not the case. Thanks anyway for untagging and also thanks also for your responses in this discussion. Help much appreciated.
rgds
kish