Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 calculate total for each quarter

Author  Topic 

ntn104
Posting Yak Master

175 Posts

Posted - 2014-02-20 : 08:45:51
I created a webpage that shows result of each quarter sale information....and I want to add sumary row of 4 quarters for the year; How do I write a code to calculate that?

The quarter field data format as '02Q08' (02=quarter 2, Q=quarter, 08=year 2008)

Thanks,

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2014-03-18 : 06:23:24
Why save the data in that format ?

Why not a row for each value ? You can use a gridview and customize the result sets based on the db values, using the object data source.
Go to Top of Page
   

- Advertisement -