Problem with data formula (string = '')

slribeiro — Fri, 15 Jul 2016 14:12:50 GMT

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.

Re: Problem with data formula (string = '')

Fri, 15 Jul 2016 14:24:35 GMT

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.