Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to freeze a point in chart and trying achieve it by using following expression.
=if(AgeFromCurrentV=$(vMinAgeFromCurrentV),AgeFromCurrentV,AgeFromCurrentV+Num(vLife))
vMinAgeFromCurrentV will have the minimum Age Value.
The expression seems give desire results with a hardcode value but it fails with "No numeric values on the x-axis" error when i introduce the vMinAgeFromCurrentV variable.
It is obvious.
Why you want to hard code ?
Hi,
Try like this by removing $ symbol
=if(AgeFromCurrentV=vMinAgeFromCurrentV,AgeFromCurrentV,AgeFromCurrentV+Num(vLife))
or
=if(AgeFromCurrentV='$(vMinAgeFromCurrentV)',AgeFromCurrentV,AgeFromCurrentV+Num(vLife))
Regards,
Jagan.
Hi Jagan,
Still no luck, with your expression the chart get rendered but the minimum point doen't get freeze it moves while changing vLife ,
Regards
K
HI,
Check this value in text object =Num(vLife) and see whether you are getting any value, if you are getting value then it should definitely change. If not can you attach sample file?
Regards,
Jagan.