pulling a calculated field from two separte fields

Question

Hello,
I have a table that is fed by a dataset. The dataset is a stored procedure that returns two lines associated with each employee. They are sorted by the indicator so line 1 is always followed by line 2. For example:

EmpID...Indicator..........Mon......Tues.....Wed.....Tot....pointValue

123456.......X....................3...............4..........4...........11
123456.......Z....................W............W.........W.........12......... .917

So the SSRS report shows the two lines for each employee. The question. I need to take the Tot from Line 1 (11) and Divide it by the Tot in line 2 (12) and display the point value in a column (pointValue) at the end of each line 2.
Is this possible?
Thanks for your time!

Answer 1

Hi,
You could try in the pointValue column use expression as :

= FormatNumber(Fields!Tot.value/Previous(Filelds!Tot.value),3)  

See reference : Report Builder Functions - Previous Function

Regards,
Lukas