Can't create NA mask

Apr 1, 2015 1:05PM

I am trying to create a boolean mask to use with exportMeasure. The mask should be true for every cell that isn't NA.

This is the logic: namask=if(pllfbopr != navalue(pllfbopr), TRUE, FALSE)

But its not working, as can be seen by the execution steps below. Should U be using something besides "navalue(pllfbopr)" for the comparison??

$> printMeasureInfo -d ../domains/STK_MFP -measure pllfbopr -all

/opt/rpas/oretail/DEV/rpas_env/MFP/domains/STK_MFP/data/plcpbopr

real

"LF Opening Inv â¬"

pllfbopr

"Planner Last Forecast"

False

ps

pst

total

"pst"

-1.7976931348623e+308:1.7976931348623e+308

0

vndrchnlclssmnth

20150327223323614

1844

$> regmeasure -d /opt/rpas/oretail/DEV/rpas_env/MFP/domains/STK_MFP -add namask -type boolean -baseint mnthclsschnlvndr -db data/namask

Retail Predictive Application Server (MOSC)