Relationship calculation between 2 apps

Comments

3 comments

  • Rainer Grabowski

    Hi Richard,

    you calculation is wrong. The var estimate must be @all of...  not @sum of ...

    Rainer 

    0
    Comment actions Permalink
  • Siddharth Srinivasan

    Hi Guys,

    var GRI = @All of Greeting and addressing the respondent a ; // Text items in another app and that app contains just one row and no more rows will be added
    var GRA = @All of Greeting and Addressing the Respondent; // Text items in another app and that app contains just one row and no more rows will be added
    var Item = @Line Item; //Text field in this app
    var Defect = 0;

    for(i=0;i<=3;i++)
    {
    if(Item == GRI)
    {
    Defect == GRA

    }
    }
    GRI

    Here im trying to compare 'GRI' and ' Item ' which are both text fields and display GRI, ideally i would want to display 'Defect' however if 'GRI' doesent populate then the calculation in the if will fail.

    My problem is GRI is a text field in another app and is not being displayed for some reason (i have tried putting GRI[i] and also tried converting the @ all of to string , on converting to string it takes the code but no output and without conversion it wont take the code and say undefined result type ...please help

    0
    Comment actions Permalink
  • Rainer Grabowski

    Hi Siddharth,

    I'm not sure if I understand waht you want to achieve. Some questions:

    1. Are GRI and GRA different apps?
    2. Is there more than one GRI or more then one GRA item related to the app A (where the calculation field is in) or always only 1?
    3. Why do you use <=3 in the for-loop?
    4. What should be the result if item == GRI and what if item != GRI?

    Rainer

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk