Hi ,
Our requirement is to have 3 Value prompts and 6 text prompts {no.s only }--- (Lower Limit1,2,3 and Upper Limit 1,2,3).
User selects 3 values in first value prompt and 3 values in 2nd Value prompt and enters Lower Limit1 ,Lower Limit 2,Lower Limit 3 and Upper Limit 1,Upper Limit 2,Upper Limit 3.
Comparison needs to be done between :
1st Value in first Value prompt with 1st Value in 2nd Value prompt and 1st lower and upper limit
2nd Value in first Value prompt with 2nd Value in 2nd Value prompt and 2nd lower and upper limit
3rd Value in first Value prompt with 3rd Value in 2nd Value prompt and 3rd lower and upper limit
Can anyone advice how this can be achieved.
Thanks in advance
Hi,
Ok, let try to understand your issue more clearly, you mention you have 3 value prompt but I only see you talk abt 1st and the 2nd value prompt is the 3rd value prompt relevent? I mean I'm assuming that this 3rd is filter the query something like [product color] = ?3rd value prompt? and the other prompts function of the unit driver to be used in a data item.
Next question, you mention 6 text prompts {no.s only}--- (lower limit 1 is this a unit like "15", lower limit 2 is "10" and so on...), if yes then see the below logic to apply.
I think this is what you trying to acheive.
data item1 column statement something along this line
?First Prompt? = "1st Value" and ?second Prompt? = "1st Value" then ?first lower limit 1 value?
OR
?First Prompt? = "2nd Value" and ?second Prompt? = "2nd Value"then ?second lower limit 2 value?
OR
?First Prompt? = "3rd Value" and ?second Prompt? = "3rd Value" then ?third lower limit 3 value?
data item 2 column statement something along this line
?First Prompt? = "1st Value" and ?second Prompt? = "1st Value" then ?first upper limit 1 value?
OR
?First Prompt? = "2nd Value" and ?second Prompt? = "2nd Value"then ?second upper limit 2 value?
OR
?First Prompt? = "3rd Value" and ?second Prompt? = "3rd Value" then ?third upper limit 3 value?
For comparsion variance data item 1 - data item 2
I hope you can follow this.
Thanks,
RK