6 Replies Latest reply: Nov 14, 2013 11:19 AM by Aurélien Martinez RSS

    Issue with Inputfield

    Niranjan k

      Hi All,

       

      I have an issue

       

      i have one inputbox and tablebox

      if i enter 100 in inputbox it will calculate as per my equation in tablebox,

      here i need to edit the values in values for that im using script in inputfield ,

      here im facing the issue if i give 100 in inputbox its not working and it not calculating the values

       

      Some one help me Please find the Screen shoot and QVW

       

      Thanks ,

      Niranjan

        • Re: Issue with Inputfield
          Aurélien Martinez

          Hi,

           

          You want to divide Values1 by TMB1?

          comm.png

           

          If is that you can try :

           

          Values1

          /$(TMB1)

           

          on Straight Table expression.

           

          Regards,

          Aurélien

            • Re: Issue with Inputfield
              Niranjan k

              yes ,but if i use inputfield in script ,

              in dashboard if i enter values in inputbox tablebox values are not changing

               

              help me

               

              Thanks,

              Niranjan

                • Re: Issue with Inputfield
                  Aurélien Martinez

                  Try this script:

                   

                  LET Newspaper1=round($(TMB1)*2/100);
                  LET Onlineadvertising1=round($(TMB1)*20/100);
                  LET Searchspends1=round($(TMB1)*20/100);
                  LET Trailers1=round($(TMB1)*20/100);
                  LET Banners1=round($(TMB1)*1/100);
                  LET OOH1=round($(TMB1)*5/100);
                  LET Displays1=round($(TMB1)*4/100);
                  LET Theatrespends1=round($(TMB1)*5/100);
                  LET TVNational1=round($(TMB1)*20/100);
                  LET TVregional1=round($(TMB1)*3/100);
                  
                  Movie1:
                  LOAD * INLINE [
                  Spends1,Values1
                      Newspaper, $(Newspaper1)
                      Online advertising, $(Onlineadvertising1)
                      Search spends, $(Searchspends1)
                      Trailers, $(Trailers1)
                      Banners, $(Banners1)
                      OOH, $(OOH1)
                      Displays, $(Displays1)
                      Theatre spends, $(Theatrespends1)
                      TV National, $(TVNational1)
                      TV regional, $(TVregional1)
                  ];
                  
                  
                  INPUTFIELD Values2;
                  NoConcatenate
                  Movie2:
                  LOAD
                    Spends1,
                    Values2
                  Resident Movie1
                  ;
                  
                  
                  Drop Table Movie1;
                  

                   

                  That you want?

              • Re: Issue with Inputfield
                Clever Anjos

                Are you reloading your app, when you change the value?

                Because, you´re calculating those values at script level

                • Re: Issue with Inputfield
                  Niranjan k

                  Hi All,

                   

                  previous if i enter any value in inputbox it will share percentage wise

                  now if i enter any value in inputbox not working plz find the attachement

                   

                  Thanks

                  Niranjan