The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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} )