Attached is a description of what I would like to do.
I am not good at math.
I am not good at math.
Alpha Software Mobile Development Tools: Alpha Anywhere | Alpha TransForm |
case(between(num,3,4),1,num=5,2,num=6,3,num=7,4,between(num,8,15),5,between(num,16,23),6,between(num,24,31),7,between(num,32,39),8,num>39,9)
case(between(num,3,4),0,num=5,1,num=6,2,num=7,3,between(num,8,15),4,between(num,16,23),5,between(num,24,31),6,between(num,32,39),7,num>39,8)
case(between(tablecount("llama_data","class = "+class),3,4).and.placed = 1,1,tablecount("llama_data","class = "+class)=5,case(placed=1,2,placed=2,1),tablecount("llama_data","class = "+class)=6,case(placed=1,3,placed=2,2,placed =3,1),tablecount("llama_data","class = "+class)=7,case(placed=1,4,placed=2,3,placed =3,2,placed=4,1),between(tablecount("llama_data","class = "+class),8,15),case(placed=1,5,placed=2,4,placed =3,3,placed=4,2,placed=5,1),between(tablecount("llama_data","class = "+class),16,23),case(placed=1,6,placed=2,5,placed =3,4,placed=4,3,placed=5,2,placed=6,1),between(tablecount("llama_data","class = "+class),24,31),case(placed=1,7,placed=2,6,placed =3,5,placed=4,4,placed=5,3,placed=6,2,placed=7,1),between(tablecount("llama_data","class = "+class),32,39),case(placed=1,8,placed=2,7,placed =3,6,placed=4,5,placed=5,4,placed=6,3,placed=7,2,placed=8,1),tablecount("llama_data","class = "+class)>39,case(placed=1,9,placed=2,8,placed =3,7,placed=4,6,placed=5,5,placed=6,4,placed=7,3,placed=8,2,placed=9,1))
case( between(tablecount("llama_data","class = "+class),3,4).and.placed = 1,1, tablecount("llama_data","class = "+class)=5,case(placed=1,2,placed=2,1), tablecount("llama_data","class = "+class)=6,case(placed=1,3,placed=2,2,placed =3,1), tablecount("llama_data","class = "+class)=7,case(placed=1,4,placed=2,3,placed =3,2,placed=4,1), between(tablecount("llama_data","class = "+class),8,15),case(placed=1,5,placed=2,4,placed =3,3,placed=4,2,placed=5,1), between(tablecount("llama_data","class = "+class),16,23),case(placed=1,6,placed=2,5,placed =3,4,placed=4,3,placed=5,2,placed=6,1), between(tablecount("llama_data","class = "+class),24,31),case(placed=1,7,placed=2,6,placed =3,5,placed=4,4,placed=5,3,placed=6,2,placed=7,1), between(tablecount("llama_data","class = "+class),32,39),case(placed=1,8,placed=2,7,placed =3,6,placed=4,5,placed=5,4,placed=6,3,placed=7,2,placed=8,1), tablecount("llama_data","class = "+class)>39,case(placed=1,9,placed=2,8,placed =3,7,placed=4,6,placed=5,5,placed=6,4,placed=7,3,placed=8,2,placed=9,1))
case(between(tablecount("llama_data","class = "+class),3,4).and.placed = "1",1,tablecount("llama_data","class = "+class)=5,case(placed="1",2,placed="2",1),tablecount("llama_data","class = "+class)=6,case(placed="1",3,placed="2",2,placed ="3",1),tablecount("llama_data","class = "+class)=7,case(placed="1",4,placed="2",3,placed ="3",2,placed="4",1),between(tablecount("llama_data","class = "+class),8,15),case(placed="1",5,placed="2",4,placed ="3",3,placed="4",2,placed="5",1),between(tablecount("llama_data","class = "+class),16,23),case(placed="1",6,placed="2",5,placed ="3",4,placed="4",3,placed="5",2,placed="6",1),between(tablecount("llama_data","class = "+class),24,31),case(placed="1",7,placed="2",6,placed ="3",5,placed="4",4,placed="5",3,placed="6",2,placed="7",1),between(tablecount("llama_data","class = "+class),32,39),case(placed="1",8,placed="2",7,placed ="3",6,placed="4",5,placed="5",4,placed="6",3,placed="7",2,placed="8",1),tablecount("llama_data","class = "+class)>39,case(placed="1",9,placed="2",8,placed ="3",7,placed="4",6,placed="5",5,placed="6",4,placed="7",3,placed="8",2,placed="9",1))
case(between(tablecount("llama_data","class = "+class),3,4).and.placed = "1",max(val(placed),0),tablecount("llama_data","class = "+class)=5,max(3-val(placed),0),tablecount("llama_data","class = "+class)=6,max(4-val(placed),0),tablecount("llama_data","class = "+class)=7,max(5-val(placed),0),between(tablecount("llama_data","class = "+class),8,15),max(6-val(placed),0),between(tablecount("llama_data","class = "+class),16,23),max(7-val(placed),0),between(tablecount("llama_data","class = "+class),24,31),max(8-val(placed),0),between(tablecount("llama_data","class = "+class),32,39),max(9-val(placed),0),tablecount("llama_data","class = "+class)>39,max(10-val(placed),0))
case(between(dbcount("llama_data","class",class),3,4).and.placed = "1",max(val(placed),0),dbcount("llama_data","class",class)=5,max(3-val(placed),0),dbcount("llama_data","class",class)=6,max(4-val(placed),0),dbcount("llama_data","class",class)=7,max(5-val(placed),0),between(dbcount("llama_data","class",class),8,15),max(6-val(placed),0),between(dbcount("llama_data","class",class),16,23),max(7-val(placed),0),between(dbcount("llama_data","class",class),24,31),max(8-val(placed),0),between(dbcount("llama_data","class",class),32,39),max(9-val(placed),0),dbcount("llama_data","class",class)>39,max(10-val(placed),0))
case(between(tablecount("llama data","Classid = "+Classid),3,4).and.placed = 1,max(placed,0),tablecount("llama data","Classid = "+Classid)=5,max(3-placed,0),tablecount("llama data","Classid = "+Classid)=6,max(4-placed,0),tablecount("llama data","Classid = "+Classid)=7,max(5-placed,0),between(tablecount("llama data","Classid = "+Classid),8,15),max(6-placed,0),between(tablecount("llama data","Classid = "+Classid),16,23),max(7-placed,0),between(tablecount("llama data","Classid = "+Classid),24,31),max(8-placed,0),between(tablecount("llama data","Classid = "+Classid),32,39),max(9-placed,0),tablecount("llama data","Classid = "+Classid)>39,max(10-placed,0))
Comment