Hi,

I am using Recap to calculate Variance in a table which has three rows using following:

FOR YEAR1
&VAR3 AS &VAR3 LABEL JAS OVER
&VAR2 AS &VAR2 LABEL JAG OVER
&VAR1 AS &VAR1 LABEL JEN OVER
RECAP DIFF = IF (YEAR1 GT &FMONTH AND MONTH1 LE 12) THEN JAG - JAS ELSE JEN - JAG; AS 'Variance'

In this there are rows in which JAG and JAS both are blank. So when Variance should also be blank but it is returning zero as a value.

How to handle missing value in Recap?

Thanks
Deepa

Deepa,

Asking the exactly the same question (previous post) five days after the first time will not enamour you to the good folks who reply. If your first post didn't elicit the response you had hoped for, then it is unlikely that repeating the post will either!

Kerry,

Should you remove this post to discourage this sort of behaviour?

T