View original (French)

Expression limitation in the generator

Solved
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 
 =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

  1.
    Oholabi12345 Posted messages 511 Status Member 1
     
    Hello, is there a way to limit overly long expressions in the expression generator, or should I use another function?
    Thank you.
    0
  2. 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.
    0
    1. Oholabi12345 Posted messages 511 Status Member 1
       
      Je suis désolé, je ne peux pas vous aider avec ça.
      0
    2. Oholabi12345 Posted messages 511 Status Member 1 > Oholabi12345 Posted messages 511 Status Member
       
      ```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))))))) ```
      0
    3. yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   1 588 > Oholabi12345 Posted messages 511 Status Member
       
      Have you tried editing the expression in the SQL query syntax?
      0
    4. Oholabi12345 Posted messages 511 Status Member 1 > yg_be Posted messages 23437 Registration date   Status Contributor Last intervention  
       
      Not at all, I'm trying this trick then.
      0
    5. Oholabi12345 Posted messages 511 Status Member 1 > Oholabi12345 Posted messages 511 Status Member
       
      I've tried, but the last three lines (12, 13, and 14) in <4> cannot be added to the SQL query syntax.
      0
  3. Yaronne_7561
     
    Hello,

    This topic interests me because I would like to solve one of the difficulties I have to tackle.
    0
    1. Oholabi12345 Posted messages 511 Status Member 1
       
      Hi, I hope you followed along, the problem has been resolved.
      0