Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - After group by date, the value is differe
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

After group by date, the value is differe
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
ngaisteve1 View Drop Down
Groupie
Groupie
Avatar

Joined: 26 December 2002
Location: Malaysia
Status: Offline
Points: 169 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ngaisteve1 Quote  Post ReplyReply Direct Link To This Post Topic: After group by date, the value is differe
    Posted: 20 October 2004 at 5:10am
Hi! I have a complicated problem here. So, I think it is better if you can login to take a look of my problem. User ID and password is tester

http://portfolio.findingsteve.net/production_system/member_l ogin.asp

There are 2 sample sales report inside. The focus is DK No 0826 which is in page no 7 in sales report 2 and date 22-05-2004 in sales report 1.

How come after group together in one date, the value change?

My code is in

http://portfolio.findingsteve.net/production_system/sample_s ales_report_code.zip

I have put necessary code there. I zip it because I don't how to display my length code. Thanks.
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 20 October 2004 at 10:00am
Did not take a look at your code but when you do a group by date it is very likely that other values change, this is by design generally and is up to you to say how you want other fields to be displayed, meaning what aggregate function they are applied to like AVG or SUM. Unfortunately your description is not very descriptive as I could not find the dk826 in report 1 (maybe I am just blind) and do not know what value you are talking about as there are a bunch.
Blog | MPG Tracker
Back to Top
ngaisteve1 View Drop Down
Groupie
Groupie
Avatar

Joined: 26 December 2002
Location: Malaysia
Status: Offline
Points: 169 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ngaisteve1 Quote  Post ReplyReply Direct Link To This Post Posted: 21 October 2004 at 12:39am

First of all, thanks because that really takes up time. Actually, you can't see dk no 0826 because it is group by date. When you go to sales report 2, you will be able to see that there are 5 dk no under the same date, 22-05-2004. Since sales report 1 is group by date, we will be able to see only one of the dk no.

Actually the right amount is 2716 and not 3122. I have deep calculation inside but the difference is 3122 is the gross while 2712 is the net (after minus the discount).
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.