topic Re: Variable interpreted as a division operation instead of a string label in App Development

Variable interpreted as a division operation instead of a string label

brunov86 — Mon, 26 Feb 2024 17:04:37 GMT

Hi everyone,

I'm facing an issue with a variable in my chart. It's being interpreted as an operation instead of a string label.

Here's what I'm trying to achieve:

I want to display the year range like "2019/2020", "2020/2021", and so on.

In the variable editor, here's my formula:

=if(Month(Today())>=4, (Year(Today()))&' / '&(Year(Today())+1), (Year(Today())-1)&' / '&(Year(Today())))

I've tried adding the Text function, but it's still not working as expected and keep getting interpreted as a division operation.

Any suggestions on how to fix this?

Thanks in advance for your help!

vinieme12 — Tue, 27 Feb 2024 05:06:53 GMT

IF are you using a Variable for the Dimension! then remove the leading = sign from the variable definition that will fix it

Or you can just use YearName() function as below

=YearName(today(),0,4)

=Replace(YearName(today(),0,4),'-','/')

brunov86 — Wed, 28 Feb 2024 15:13:53 GMT

Thanks Vineeth.

Works like a charm !

I used Replace(YearName(today(),0,4),'-','/') as suggested.