Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there
Please find attached.
The model is self explanatory. I'm trying to do a Set Analysis in the Blue Text box for the Current Fin Year (20/21) and it should return 5.17, but it doesnt. I'm almost sure it is the syntax, because FY is Dual.
1. From research I have done I got - the set comparison always compares against the text value of a dual. So I created a variable called vFY.
2. The result that I am getting is not correct. what is wrong with my Set Analysis?
Much appreciated.
Thank you.
Try setting your FY to something else text wise. When I simply $(vFY) it yields the math from 20/21.