1 Reply Latest reply on Aug 12, 2013 1:13 PM by 989257

    Smartview - Send NODATA

    Vukasin Prunic


      is it possible to send via Smartview NODATA to HFM?


      The point is to erase periodic data (not to replace it with ZERO!)


      Thank you in advance,



        • 1. Re: Smartview - Send NODATA

          In conjuction with turning on the Submit Zero option under your Smartview options, you can simply enter either #Missing or #NumericZero into the data form in Smartview and click Submit.  Both of these functions clear the data rather than replace it with a zero.


          I often use this in conjunction with an IF statement (for both data forms and functions) so if a value previously submitted is now zero in Excel, it will be cleared on any subequently submission.  eg.  =IF(A1=0,"#NumericZero",A1)