Hi,

I am using Recap to calculate Variance in 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

Perhaps just adding the zero suppress option to the DIFF definition will help.

Thanks Leah!!!

But the thing is it will suppress where ever zero will come. My requirement is whenever there is BLANK in JAG and JAS in the Variance row it should appear as BLANK instead it is showing zero

hi deepa,
You can paste the screenshot of your present output and the requirement you want in
www.tinypic.com

regards

Deepa,

Check out the usage of MISSING in a RECAP / DEFINE / COMPUTE and rearrange your calculation accordingly.

T