Ad hock heat map chart

[Ethel]

Hello dear community!

Can you please help me with this task?

My end user wants to have ad hoc heat map chart. To do this, I'm trying to write this formula in one of dimensions

if(SubStringCount(Concat([_Dimensions], '|'), 'Fiscal Year')=1,FiscalYear).

This part of formula(SubStringCount(Concat([_Dimensions], '|'), 'Fiscal Year')=1)

is working correctly when I put it in text box like this(if(SubStringCount(Concat([_Dimensions], '|'), 'Fiscal Year')=1,5) it shows 5 in text box)

formula if(1=1, FiscalYear) is working fine for heatmap dimension.

Why my formula is not working and how can I make it work?

Thank you so much!!!!