Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: Array number with Filter option needs one column with formula

Array number with Filter option needs one column with formula 6 months 3 weeks ago #104855

  • pmp
  • pmp's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 20
  • Karma: 0
I am just trying to figureout how to add the validation on the 'Self ' column - exepected value between 1 and 5 and the % column totals ( for all the rows) should not exceed 100. I tried giving it in the question validation but it didnt work.

Any help would be highly appreciated.

Thanks
PMP
The administrator has disabled public write access.

Array number with Filter option needs one column with formula 6 months 3 weeks ago #104881

  • pmp
  • pmp's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 20
  • Karma: 0
is there a way I can set validation on Self ( each cell) like value should be between 1 to 5 and % total should not be more that 100%?

I tried using the sub question /question validation option and it didnt work. any help would be appreciated
The administrator has disabled public write access.

Array number with Filter option needs one column with formula 6 months 3 weeks ago #104887

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6277
  • Thank you received: 802
  • Karma: 241
Hi,

Question validation equation : sum(self)<100
Question validation tip : Not more than 100% (actual {sum(self)}%
Sub-question validation equation : this>=1 and this<=5
Sub-question validation tip : Each answer must be between 1 and 5

Something like that ?

Denis
The administrator has disabled public write access.

Array number with Filter option needs one column with formula 5 months 2 weeks ago #106441

  • pmp
  • pmp's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 20
  • Karma: 0
Can somebody help to resolve this.

I have a Array Number. What I need is one column will have predefined values ( read only mode).
and the next two columns input should validate based on this read only column value.
Also final total at the end for the two input columns.

I used some sample code give earlied and tried to achive, but somehow i am not able to get what i want.

If someone can help me to how to assign values to the particular array column and make read only and also how to use the validation based on the value in there. Attached a screen In this i gave the maximum value in the parenthesis as part of the Y Scale sub questions. Ideally this should have been a seperate read only column with assigned values.

Thanks in advance
Attachments:
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.149 seconds
Donation Image