Skip to Content
0
Former Member
Mar 13, 2009 at 07:27 PM

Missing formulas - how to display?

20 Views

I'm using CR2008.

I have a list of medical observations that I want to display in a group footer. I have one formula, @LDLDate, that says

If {Command.OBSNAME} = "LDL" Then
   {Command.OBSDATE}

Then, I have another one, @LDLDateShow, that reads

Maximum({@LDLDate}, {Command.PID});

If there's an LDL observation for a patient, the date displays properly. If not, nothing displays in the group footer. All well and good, but there's nothing I can operate on, either. I tried setting a Display String to be

If IsNull({@LDLDateShow}) Then
    "(none)"
Else
    ToText(@LDLDateShow, "MM/dd/yyyy");

But still, nothing displays. How can I change this to work properly? Thanks.

Edited by: Garrett Fitzgerald on Mar 13, 2009 3:28 PM

Edited by: Garrett Fitzgerald on Mar 13, 2009 3:30 PM fixed formatting