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


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

First port of call would be

RECAP DIFF MISSING ON = IF (YEAR1 GT &FMONTH AND MONTH1 LE 12) THEN JAG - JAS ELSE JEN - JAG; AS 'Variance'

Hi Hammo1j,

I alraedy tried this option but it didn't work. It gives error!!!

Thanks
Deepa