Expression limitation in the generator
Solved
Oholabi12345
Posted messages
511
Status
Member
-
Oholabi12345 Posted messages 511 Status Member -
Oholabi12345 Posted messages 511 Status Member -
Hello,
In my expression generator, I notice that overly long expressions cannot be contained; that is to say when I have several nested iifs; here it is
the part in bold and underlined cannot be entered into the request generator
Configuration: Windows / Firefox 92.0
In my expression generator, I notice that overly long expressions cannot be contained; that is to say when I have several nested iifs; here it is
=IF(0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))/O6<=(300000/12), 0, IF(0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))/O6<=(547000/12), 0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))/11-O6*27273/12, IF(0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))/O6<=(979000/12), 0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))*15/115-O6*48913/12, IF(0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))/O6<=(1519000/12), 0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))*20/120-O6*84375/12, IF(0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))/O6<=(2644000/12), 0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))*25/125-O6*135000/12, IF(0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))/O6<=(4669000/12), 0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))*35/135-O6*291667/12; <ital><underline>IF(0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))/O6<=(10106000/12), 0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))*45/145-O6*530172/12, 0.85*(0.8*ROUND(I16/1000,0)*1000-(Q18+Q19))*60/160-O6*1183594/12)))))))<underline /></underline></ital>
the part in bold and underlined cannot be entered into the request generator
Configuration: Windows / Firefox 92.0
3 answers
Hello, is there a way to limit overly long expressions in the expression generator, or should I use another function?
Thank you.
Thank you.
yg_be
Posted messages
23437
Registration date
Status
Contributor
Last intervention
Ambassadeur
1 588
Hello,
I don't quite understand the context.
It looks like an Excel formula, and the question is asked in the Access forum.
I don't quite understand the context.
It looks like an Excel formula, and the question is asked in the Access forum.
```sql
IGR:VraiFaux(0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))/[NBRE PART]<=25000, 0,
IIF(0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))/[NBRE PART]<=(547000/12),
0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-[ITS]+[CN])/11-[NBRE PART]*27273/12,
IIF(0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))/[NBRE PART]<=(979000/12),
0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))*15/115-[NBRE PART]*48913/12,
IIF(0.85*(0.8*Round([I16]/1000,0)*1000-([ITS]+[CN]))/[NBRE PART]<=(1519000/12),
0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))*1/6-[NBRE PART]*84375/12,
IIF(0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))/[NBRE PART]<=(2644000/12),
0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))*25/125-[NBRE PART]*11250,
IIF(0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))/[NBRE PART]<=4669000/12,
0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))*35/135-[NBRE PART]*291667/12,
IIF(0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))/[NBRE PART]<=(10106000/12),
0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))*45/145-[NBRE PART]*530172/12,
0.85*(0.8*Round([SALAIRE BRUT]/1000,0)*1000-([ITS]+[CN]))*60/160-[NBRE PART]*1183594/12)))))))
```