If no result comes back set "none" otherwise write it

[LouLu]

I have created a statement that says

=If IsNull(<Input Cost>) Then &quot;none&quot;

so it writes none if there is no data back from the database

I need to extend the if to say - else write the <Input Cost> anyway

If i try to do this with the measure I get a syntax error.

Please help !!

 

[bcauser]

why are you creating a variable for it man. All you need to format the cell thats alll.... type none in the undefined area and ur problem will get solved