Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Link between rows

Hi all,


I have trouble to find a solution to build a report because the answer of the first question of the job will depend on how many set of questions will then appear :
In my Useranswer table, I am currently not able to link which price goes with which category, origin, ...
AnswerText in red should refer to the price in the red circle.
AnswerText in green should refer to the price in the green circle.

(to calculate the average price for the category 300-400g for exemple)  

Currently, I am not able to determine that.
Any idea ? Thanks!

 

 

1 Reply

  • az38's avatar
    az38
    Community Champion

    Hi Anonymous 

    from your data example its almost unbelievable to understand your logic

    what answernumeric should be used for "Hors promo" and "Non" answers?