May I ask for help in solving my issue on coalesce. I have used the formula you have shared in the forum: coalesce(${Total},0)+coalesce(${Total_outside},0)+coalesce(${Total_one_within},0)+coalesce(${Total_one_outside},0), however, the result I have is 0 (ZERO). This should not be the cased as the scores being coalesced are ranging from 1-2. Here’s the link to the file: G-ESG Rapid Assessment Tool | KoboToolbox (humanitarianresponse.info).
Sorry, I forgot to add a note type question. Another problem I have is how to reflect the level of capacity with the score that an organization has. What formula to use?
Can you please help me on using If function? I wanted to have a formula that give me the level of capacity when the score is within the range of If formula. Example: if((${_Total_GE} <= 3), “Gendered Environmental Unaware”, if((${_Total_GE} >= 4 and ${_Total_GE} <= 6), “Gendered Environmental Aware”, if((${_Total_GE} >= 7 and ${_Total_GE} <= 9), “Gendered Environmental Responsive”, if((${_Total_GE} >= 10 and ${_Total_GE} <= 12), “Gendered Environmental Transformative”)))). However, my formula is not working.
May I ask for your assistance in resolving an issue in the app? When I was already using the app an error occurred in the process: " Error evaluating field ‘_Total_GE_R’ (…)… Xpath evaluation cannot handle function ‘if’ requires 3 arguments. Only 2 provided.
This issue however did not happen in the web browser.