There is one field called FINAL_OUTCOME which includes Pass, Fail & cancelled as the values (P,F,C). I want to have a calculated field calculating a DATE DIFF between start time and end time which is only for the paas(P) fields and not the F and C. all the data coming from a single table.
Can anyone help me on this?? Is this be going to solve by parameters of calculated field only..
create a parameter and pass it to the calculation's CASE function and return the results.