Good day,
I created a helper Field [YearsTenure] and not trying to create another field to highlight Milestone Flag, but keep on getting Parse Error. I tried these 2 options:
if [YearsTenure]=5 then '5' AND
if [YearsTenure]=10 then '10' AND
if [YearsTenure]=15 then '15' AND
if [YearsTenure]=20 then '20' AND
if [YearsTenure]=25 then '25' AND
if [YearsTenure]=30 then '30'
else 'Non Milestone'
endif
--------------------------------
if [YearsTenure]=5 then [YearsTenure] AND
if [YearsTenure]=10 then [YearsTenure] AND
if [YearsTenure]=15 then [YearsTenure] AND
if [YearsTenure]=20 then [YearsTenure] AND
if [YearsTenure]=25 then [YearsTenure] AND
if [YearsTenure]=30 then [YearsTenure] AND
if [YearsTenure]=35 then [YearsTenure]
else 'No Milestone'
endif
Also instead of 'number', I tried to insert [YearsTenure] to return the 5/10/15/etc if the value matches...
Can't figure out what am I doing wrong...I also tried switching from string to double/int that didn't fix the issue either.
