calculation not working with hidden column or with symbol atted
I am using this expression in a pivot table to show a value. I have the '<' in as I need the target to show as <5% etc. This will show fine in the column I am using this expression in but I am also using the column to calculate a variance and it will not work because of this '<'
Expression in my Target YTD Column that i use for variance calculation below also: