Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
QFanatic
Creator
Creator

Assist with Set Analysis and Dual Variable

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.

Labels (2)
1 Reply
Dalton_Ruer
Support
Support

Try setting your FY to something else text wise. When I simply $(vFY)  it yields the math from 20/21. 

Dalton_Ruer_0-1620244967248.png