Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I'm trying to implement a algorithm that for today (15/07) should appear always the YTM value (06/2016).
When we don't have selections should show "> 06.2016" and when we are using selections should appear the value of selection (ex: "> 04/2015"
When I do select it works perfectly:
But then when I remove my selections it appears like this (without the calculation) and what bothers me is that the same formula works on a text box:
Formula without selections:
'> ' & max({1<Facts.LYTM_Flag={'1'}>}date(%Date,'MM.YYYY'))
Formula with selections:
'> '& max(date(addyears(%Date,-1),'MM.YYYY')))
If you could help me I really apreciate.
Many thanks
and best regards.
use de functio getselectcount:
if(GetSelectedCount(your fied)>0,'> '& max(date(addyears(%Date,-1),'MM.YYYY'))),'> ' & max({1<Facts.LYTM_Flag={'1'}>}date(%Date,'MM.YYYY')))
you can beter de expression.