How to use like condition within IF-ELSE condition in RTF/BI Publisher
Hello Folks,
Can somebody please help me with below requirements to achieve.
I want to display heading value as null in report if below condition does meet the criteria else 'Gross Units'.
While using like condition it does not work
Approach#1
<?xdofx:if (g4_Title_RULE like '%First%Title%Desc%' or Q4_ROYALTY_EARNINGS_RULE like '%Second%Title%Desc%')
then ''
else
'Gross Units'
end if?>
Approach#2
<?xdofx:if (@row:starts-with(Q4_ROYALTY_EARNINGS_RULE,'Multi') or @row:starts-with(Q4_ROYALTY_EARNINGS_RULE,'Single '))
then ''
else
'Gross Units'
end if?>
Thanks in advance, please as soon possible, requirement is quite critical.