Hello Crystal guru's,

I am a little confused, are you working with a null value or an actual '0' string, if so.

the formula would probably need to be
-----------
local stringvar x;
If {Column B} in ['0','00'] Then
x:={Column A}
else
x:={Column C};

x

------------

however, I am confused what null has to do with this;

also, this statement doesnt make much sense

Now I want to make a display string in Column C that when column B = 0,00 or 0 then I want to show the value of column A in Column B.

if column B = '0' or '00' then show the value of column A in column B. I don't see the relation to Column C.



Edited by comatt1 - 28 Nov 2012 at 2:43am

Yes it matters.  The question then is {Column C} also a datefield?  If so then change the local stringvar x; to local datevar x;  If {Column C} is a string then change x:={Column A} to x:=totext({Column A})  (you may need to use the optional parameter for totext to format the date the way you need it).

The bottom line, x's data type has to match whatever you are assigning it to.

I hope this helps.