Oct 20, 2020 04:24 PM
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
Oct 20, 2020 04:48 PM
Perhaps it’s the space between if and the first parenthesis? Make sure you have it formatted properly, like this:
if
IF( {revenus ou dépense}=‘revenu’, LEFT({catégorie}, 5), {revenus ou dépense} )