Hi Guys:
I have this calculation in my xls form: (I have 8 choices)
1- count-selected(${vaccination.services1})
2- if(${calculate.vaccination.services1}<=3,"30%",if(${calculate.vaccination.services1}=4,"60%",if(${calculate.vaccination.services1}=5,"60%",if(${calculate.vaccination.services1}=6,"90%",if(${calculate.vaccination.services1}=7,"90%",if(${calculate.vaccination.services1}=8,"100%","0%"))))))
Number 2 is working for all logics from (0-7) but for number 8 which contains all choices it didn't work ?
Can you advise please?
Hi @Moteb_Marei
what do you mean by
I've tested this sample form: itemsTest.xls (7 KB)
and everything seems fine.