Need a bit of help
-
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.
Cheers
-
why not
GST =(Sum(Fields!Valuation.Value * 65/100) * 125/1000)
And then again, I might be wrong ...
David Webb -
Thanks very much David for the quick response and all works well.
Cheers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply