Skip to Content
0
Jul 07, 2020 at 02:26 PM

[ERROR] A Formula cannot refer to itself, either directly or indirectly

467 Views

Hi, I'm having issues with the following 2 formulas, which surprisingly enough actually work when ran from the software, but I'd still like to clean up the legacy code for the future :

If Sum ({@PcsSld}, {@Rupt1})<0 and {ANSC_TEN.CDLG} = "FR" then "Veuillez nous communiquer le compte bancaire pour le remboursement du solde :"
else
If Sum ({@PcsSld}, {@Rupt1})<0 and {ANSC_TEN.CDLG} = "NL" then " INSERER TEXT NEERLANDAIS POUR REMBOURSEMENT :" 
else
If Sum ({@PcsSld}, {@Rupt1})<0 and {ANSC_TEN.CDLG} = "US" then "Please send us the bank account into which we can transfer the balance :"
else
If Sum ({@PcsSld}, {@Rupt1})>0 and {ANSC_TEN.CDLG} = "FR" then "Veuillez utiliser les données ci-dessous lors de votre transfer :"
else
If Sum ({@PcsSld}, {@Rupt1})>0 and {ANSC_TEN.CDLG} = "NL" then "Gelieve onderstaande gegevens te gebruiken bij uw betaling :" 
else
"Please use the following information for the transfer :" 
If Sum ({@PcsSld}, {@Rupt1})<0 then 
IF {ANSC_TEN.CDLG} = "FR" then "Solde en votre faveur :"   else
IF {ANSC_TEN.CDLG} = "NL" then "Saldo in uw voordeel :"   else
"Balance in your favour :" 
else
IF {ANSC_TEN.CDLG} = "FR" then "Solde en notre faveur :"  else
IF {ANSC_TEN.CDLG} = "NL" then "Saldo in ons voordeel :"  else
"Balance in our favour :"

What should I change in order to avoid the error?