How do I use Previous function in SSRS
reporting-services, sql, sql-server
Solution
You should be able to use:
=Previous(Sum(Fields!CurrentMV.Value))
Or
=Previous(Sum(Fields!CurrentMV.Value, "Detail"), "Detail")
More reading.
Problem
I'm working on SSRS report. There are two main fields `CurrentMV` and `PreviousMV` both are having there different formulas but I need to change field `PreviousMV` to take a value of `CurrentMV` but `previous date` value I'm trying using `Previous` function of SSRS please help me. field `CurrentMV` having expression like `=Sum(Fields!CurrentMV.Value)`