nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Handling null values in bi publisher rtf template

Jaswanth Elite

Summary

Handling null values in bi publisher rtf template

Content

My requirement is replace all zeros with - sign

<if:<?sum(current-group()/BUDGET)=0?><?'-'?><?endif?> but it throws error

Find more posts tagged with

Accepted answers

All comments

Venkat Thota - BIP

<if:sum(current-group()/BUDGET)=0?><?'-'?><?endif?>

http://www.oracleerpappsguide.com/2014/06/how-to-use-if-else-conditions-in-xml-publisher-rtf-template.html

Jaswanth Elite

brajesh,

Syntax is wrong because if budget =0 then it should replace with '-' but its not doing that in my case.

thanks

Brajesh Shukla-95078

your syntax is little bit not correct, BI tags should start with <? and these should not be nested tag like <? <?.

Below is the one working for me

<?if: sum(current-group()/BUDGET)=0?><? '-'?><?end if?>

Jaswanth Elite

thanks for the help

Venkat Thota - BIP

same condition:

<?if:field_name=''?> - <?end if?> --------if you want to replace null with -

<?if:field_name=''?> '-' <?end if?> ---if you want to replace null with '-'

<?xdofx: nvl(field_name,'-')?> ,

<?xdofx:replace(name,'','-')?>

still if you find issue , upload RTF and XML.

Jaswanth Elite

i took care that in sql now my concern is only to replace null values with '-'

Thomas Dodds

You will end up with a datatype issue ... non-ZEROs are numeric and you want to convert ZERO to non-numeric '-' ...

Venkat Thota - BIP

upload rtf and xml , Thanks

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders

Mallikarjuna Kuppauru-Oracle 51