=IF(ERROR(N25/(GETPIVOTDATA("StatusPriceAdjustedUSD_amt",'Pivot Country_IncomeProp'!$G$14,"Country_tx",M25)/1000000)-1),N25/(GETPIVOTDATA("StatusPriceAdjustedUSD_amt",'Pivot Country_IncomeProp'!$G$14,"Country_tx",M25)/1000000)-1,NULL) This function is not recognising the "NULL" at the end what am i doing wrong
Solved by G. Q. in 23 mins