3 Replies Latest reply: Nov 21, 2013 8:20 AM by Matthew Raschke RSS

    Linking two feilds by formula

      Good day,

       

      I have a prolem linking two two tables using a formula.

       

      In our business we have orders to deliver by a specific date.

       

      I want to create a list box showing me the number of days remaing to deliver the orders. (deliver by date-order date=answer)

       

      Attached herewith is a sample of a few orders and their respective dates, also QV model is attached as well.

       

      Please could you assit me in achiving this.

        • Re: Linking two feilds by formula
          Michele Barini

          Hi,

          have you tried to add a chart, set straight table, added the dimensions (Customer and Order) and then the expression (deliver by date-order date)?

            • Re: Linking two feilds by formula

              Hi,

               

               

               

              I did exactly that, but I want to do it in the background not front end.

               

               

               

              As I want to also add a list box for number of days till delivery expected which would come from deliver by date-order date.

               

               

               

              When I do what you proposed it works on the Straight Table in the front end if I make the expression (deliver by date-order date) but then when I make a list box from that calculated dimension it does not seems to relate.

               

               

               

              This is for the warehouse to check outstanding orders, but I want them to look at it in order of importance which needs to be delivered first, thus he would choose orders with no invoice for the month we in, sort that table by number of days to deliver.

               

               

               

              But it brings up -13 days 0 days etc as it brings in old orders we missed, so I want a list box where I choose 1 days or 2 days thus only seeing what truly needs to be supplied.

               

               

               

              Kind regards

               

               

               

              Matthew Raschke

               

                 

                    

              Email: matthew.raschke@ellies.co.za

              Tel:  +27 11 490 3893

               

              Cell: +27 82 318 5051

               

               

              www.ellies.co.za <http://www.ellies.co.za>  <http:// <http://> www.ellies.co.za/>

              94 Eloff Street Ext, Village Deep,

              Johannesburg,2001, South Africa.

               

               

               

              The only place success comes before work is in the dictionary

               

               

               

              P please consider the environment before printing this email

              • Re: Linking two feilds by formula

                I hope you can see pic below, the list box does not have any fields to select all greyed out ?

                 

                 

                 

                 

                 

                 

                 

                 

                 

                Kind regards

                 

                 

                 

                Matthew Raschke

                 

                   

                      

                Email: matthew.raschke@ellies.co.za

                Tel:  +27 11 490 3893

                 

                Cell: +27 82 318 5051

                 

                 

                www.ellies.co.za <http://www.ellies.co.za>  <http:// <http://> www.ellies.co.za/>

                94 Eloff Street Ext, Village Deep,

                Johannesburg,2001, South Africa.

                 

                 

                 

                The only place success comes before work is in the dictionary

                 

                 

                 

                P please consider the environment before printing this email