topic Is there A way to if I have a question of selection for Years inside repeat in survey123 connect to have A sum of certain other questions according to a certain year in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/is-there-a-way-to-if-i-have-a-question-of/m-p/871440#M28254 <HTML><HEAD></HEAD><BODY><P>Hello, Can you help me here if I can get A way of how to have a sum of certain questions e.g Annual Rent for floors based on the year I selected. I have inside a selection for year and for floor. But I want a sum based on each year. Thanks!</P></BODY></HTML> Sun, 19 Jan 2020 10:48:18 GMT AlainMunyaneza1 2020-01-19T10:48:18Z Is there A way to if I have a question of selection for Years inside repeat in survey123 connect to have A sum of certain other questions according to a certain year https://community.esri.com/t5/arcgis-survey123-questions/is-there-a-way-to-if-i-have-a-question-of/m-p/871440#M28254 <HTML><HEAD></HEAD><BODY><P>Hello, Can you help me here if I can get A way of how to have a sum of certain questions e.g Annual Rent for floors based on the year I selected. I have inside a selection for year and for floor. But I want a sum based on each year. Thanks!</P></BODY></HTML> Sun, 19 Jan 2020 10:48:18 GMT https://community.esri.com/t5/arcgis-survey123-questions/is-there-a-way-to-if-i-have-a-question-of/m-p/871440#M28254 AlainMunyaneza1 2020-01-19T10:48:18Z Re: Is there A way to if I have a question of selection for Years inside repeat in survey123 connect to have A sum of certain other questions according to a certain year https://community.esri.com/t5/arcgis-survey123-questions/is-there-a-way-to-if-i-have-a-question-of/m-p/871441#M28255 <HTML><HEAD></HEAD><BODY><P>Hi Alain,</P><P></P><P>If I understand you correctly, there are a couple of ways to do this:</P><P>- if you have a certain number of years to do the analysis for, you could create a calculate question in the repeat that if the year is a set year, grab the rent value, otherwise set the value to 0. &nbsp;That calculate question could then be totaled with a calculate question in the parent layer with a sum() function.</P><P>- if you need to have a table breakdown as the text of a question, this may&nbsp;be accomplished by using a beta feature of Survey123 - custom JS functions.</P></BODY></HTML> Fri, 31 Jan 2020 18:32:08 GMT https://community.esri.com/t5/arcgis-survey123-questions/is-there-a-way-to-if-i-have-a-question-of/m-p/871441#M28255 JamesTedrick 2020-01-31T18:32:08Z