Blank formula results

[TrentSteel]

Morning all

Alright, I know this is something stupid and small, but I just can't figure it out. I have various reports I have been working on for weeks now, streamlining, aesthetics etc. This morning I have added a few new formulas yet whenever I try to display them on the report, with only a few sporatic exceptions, they come up blank. It just won't display the value. (and no they are not supressed)
Has anyone run into this?

TIA

 

[HowardHammerman]

The fact that they are showing up "sporatically" indicates that there is something wrong with your logic. Display your code and we will have a look.

Howard Hammerman,
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[TrentSteel]

Howard

I don't think it is my code, since it is pretty simple:

datediff("s",DateTime (1970,01,01,00,00,01), currentdatetime) - {SHR_HELPDESKSLAS.TTA_SLA_TIME}( this is a Unix time field)

The problem is that I don't understand, or can't figure out really, why the results of the above formala only show up about 6 times in over 200 displayed records. I was just wondering if this had happened to anyone before and if they resolved the issue.

TIA

 

[jkob]

Sometimes when I've had a problems with formulas not showing any results even though it's a really simple thing that I'm trying to accomplish, it's because my tables have been linked incorrectly. This leads to information not being displayed and thus makes your report look as though it's not finding any results...

 

[Madawc]

Have you tested for 'isnull'? Blank formulas sounds like an isnull problem.

Madawc Williams
East Anglia, Great Britain