May 18, 2005 at 4:57 pm
OK here goes....totally blind on the sql side of things really and need a bit of help trying to get some totals to appear in a table.
Have a table that has 7 columns with the final column being where all the work is done. The 7th column needs to take the 6th columns value and get 65% of that value. Here is what I put - =Fields!Valuation.Value * 65/100. So far so good. The next line down in the 7th column subtotals the above. Then being a New Zealand thing need to add 12.5% for GST tax to the subtotal column then add the subtotal to the gst to get the grand total. So you all following me so far.
eg. 6th Column 7th Column
Detail 1 1000.00 650.00 =Fields!Valuation.Value * 65/100
Detail 2 520.00 338.00
Subtotal 988.00 =Sum(Fields!Valuation.Value * 65/100)
GST 123.50 = (heres where i need the help)
Total 1111.50
Urgent help on this would be great.
May 18, 2005 at 6:09 pm
Could you explain a little more ?!
For instance are Detail1 & Detail2 part of a single ID?!
Would there always be only 2 details associated with each ID ?
How did you get as far as you did ? Stored procedure - application code ?
Maybe you should look into "computed columns"!
**ASCII stupid question, get a stupid ANSI !!!**
May 19, 2005 at 11:57 am
looks like you are doing this totalling inside an RS report. you can do something like :
=((Sum(Fields!Valuation.Value * 65/100)) * 0.125)
in your GST field value.
or even add a new field which takes the value :
Newfield = Sum(Fields!Valuation.Value * 65/100)
GSDT field = Fields!Newfield.Value * 0.125
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply