1 Reply Latest reply: Aug 12, 2013 8:13 AM by 989257 RSS

    Smartview - Send NODATA



      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)