Help me to fix this problem

ifs(“spbj”=[KATEGORI],[spbj],“spk”=[KATEGORI],[spk],“SPK MULTIYEARS”=[KATEGORI],[SPK MULTIYEARS])

Hi @Wais_alqarni

Try to finish your expression by FALSE

ifs(“spbj”=[KATEGORI],[spbj],“spk”=[KATEGORI],[spk],“SPK MULTIYEARS”=[KATEGORI],[SPK MULTIYEARS],FALSE)

it’s not working

try this:

IFS(
	"spbj"=[KATEGORI],TEXT([spbj]),
	"spk"=[KATEGORI],TEXT([spk]),
	"SPK MULTIYEARS"=[KATEGORI], [MULTIYEAR]
)

4 Likes

You’re the best. Thank you sooooooo. much!!!

2 Likes