Help

What is wrong with my formula guys?

Topic Labels: Formulas
1030 1
cancel
Showing results for 
Search instead for 
Did you mean: 
International_H
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1

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}
)