vendredi 18 mai 2018

Check for null values BI Publisher

I am using Oracle BI Publisher and I want to set a default value in .rtf file for an attribute in case it's null. For my test data I have null value in an attribute called TOTAL and I want to set it with 10. I am assuming my syntax is incorrect but unable to find the fault. Can I get some help regarding that?

<?if:TOTAL!=''?><?format-number(TOTAL,'## ##0',’Yen’)?>,-<?end if?>
<?if:TOTAL=''?><?format-number(10,'## ##0',’Yen’)?>,-<?end if?>

Aucun commentaire:

Enregistrer un commentaire