hello, I'm wondering if these is even possible in Framework Mgr. What I'd like to do is have an IF statement where I have an end date, and if that date field is blank, then to show the IS_ACTIVE = y, otherwise hide the IS_ACTIVE field?
If
[END_DATE] = null
)
then
(
IS_ACTIVE = 'Y'
)
else
(CAST([END_DATE], DATE)
)
You don't really show/hide fields in FM. But you can certainly create calculated data items.
For example, perhaps you want IS_ACTIVE as a calculated field along the lines of: if ([END_DATE] is null) then ('Y') else ('N')
yeah that makes sense - that's a good workaround. Thanks for steering me in that direction - I wouldn't have thought of that. :)