Skip to main content

if (

{revenus ou dépense}=‘revenu’, LEFT({catégorie}, 5), {revenus ou dépense}

)


i want my key field to display different things according to what is written in another field


thanks girls and guys in advance

Perhaps it’s the space between if and the first parenthesis? Make sure you have it formatted properly, like this:


IF(

   {revenus ou dépense}=‘revenu’,

   LEFT({catégorie}, 5),

   {revenus ou dépense}

)

Reply


Terms & Conditions