combination of 'IF' condition and 'DECODE' function in TEMPLATE
I am trying to use a 'decode' function for a conditional region using 'if'. It is not giving me the right results on preview.
<?xdofx: if decode(CF_TRX_TYPE_NAME, 'AAA',’1’, 'BBB',’1’,’2’)=’1’?>
Conditional Formatting worked
<?end if?>
-- Didn't work
But, decode used seperately without 'if' clause worked.
<?xdofx:decode(CF_TRX_TYPE_NAME, 'AAA',’1’, 'BBB',’1’,’2’)=’1’?>
--Worked
Can somebody help?