INV_INVESTMENTS.Baseline_ID Null but LABOR_BASESUM show 0 or Null

Discussion created by bfarquhar on Apr 18, 2011
Hi Gurus,
I'm hoping someone can shed some light on something for me. I'm trouble shooting some SQL that I wrote for a portlet and I'm looking at the INV_INVESTMENTS table. I'm seeing projects that have no Baseline ID but have a LABOR_BASESUM of Zero... other times is shows Null for basesum.... which is what I would expect if there is not ID. Also, when there is a zero basesum the LABOR_BASELINE_CURVE is Null. How can that be ? Is there a logical explanation for this that I am missing ? Or is this bad data ?

Any thoughts would be much appreciated.