2 Replies Latest reply: Nov 19, 2013 3:26 AM by eunduck kim RSS

    Calculation, Variable

      Hi, All

       

      I have a question.

      now I have three tables.

      1) 'product' and 'price' definition

      A     100

      B     200

      C     300

       

      2) The table which can count through variables in input box

      ex. multiply

      5

      2

      7

       

      3) Last is Result.

      A     500

      B     400

      C     2100

       

      I know that top of the last table was appeared, but I want to use that total value again.

      To do that, I thought  I need one variable more and want to show that value(=variable) in text box no action.

      I don't how to explain that variable in expression.

      want to show [RESULT=3000].

       

      also

      WHY,I used other variable value in text box. but didn't appear value. impossible?

       

      thankyou

        • Re: Calculation, Variable

          Not sure if I understand you correctly.

          Per my understanding you want to display the total of "Result" column.

          You can have the total shown in the same table :

           

          Go to Properties-expressions of the table, then in total mode section, check any of the radio button to display the total in the table itself.

           

          Now, to get the total displayed in a text box, you can set a variable as Sum(Your Expression) in Variable overview and then use that variable in text box.

          PFA. hope it helps.

            • Re: Calculation, Variable

              thank you again:)

               

              I sorry already solve it before see your answer.

              thank you so much every time

               

              after checking sum in expression tab,

               

              so I tried to use your answer again '=$(vResult)'

              but that's not working

              I don't know reason exactly.....

               

              my variable name is vI

              I used it '= num(sum ($(vI)), '#,##0')'

              Its working well..

               

               

              Thank you,

              Shyamal Pandit:)