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

    Smartview - Send NODATA

    961397

      Hi,

      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,

       

      Vuk

        • 1. Re: Smartview - Send NODATA
          989257

          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)