One particular column in the report is not displaying the

Hi
One particular column in the report is not displaying the exact value of amount.
ex.
Freight Out Report
Universe : sales
columns:
Account Number
Date
Invoice Number
Freight Out

When i run the report the output for one particular account number is wrong.
Some how it is multiplying with some value and giving more Dollars for Freight_out
Can anyone help me.
Thanks


randyj262004 (BOB member since 2004-04-09)

Maybe, a fan/chasm trap in the universe? Hard to tell without knowing the universe/DB structure.


Andreas :de: (BOB member since 2002-06-20)

yES I AGREE WITH YOU,BUT I’M REALLY TO THE CURRENT COMPANY.
JOINED THIS WEEK.BUT WHEN I CHECKED THE UNIVERSE THERE ARE NO LOOPS .
ANYWAYS THANKS AND I WILL LOOK INTO THE UNIVERSE AGAIN.


randyj262004 (BOB member since 2004-04-09)

Run the SQL generated by the universe query against the database directly in SQLPLUS( for oracle) . Verify that your database returns correct results.

If results are correct then paste the query in free hand sql query and see the results.

If results come good in Free hand sql report then there is some problem in your original report.


JaiGupta (BOB member since 2002-09-12)

Thanks for the response.
Basically the error was with the date field crieteria.
Thanks


randyj262004 (BOB member since 2004-04-09)