conditional sub string with in IF condition returning both values in BI Publishe
Hi All
I am using below conditional sub string with in IF condition.
<?template:ADDR?>
<?xdofx:if (substr(ORDER_TYPE,1,3)!='FPD')then
Sample Data
Australia
12345
end if?>
<?xdofx:if (substr(ORDER_TYPE,1,3)='FPD')then
Sample Data
Australia
12345
EMI 123545
ABCD
end if?>
<?end template?>
But it is printing both the values.
Can u please help me ?
Thank You