Handling null values in bi publisher rtf template

Jaswanth Elite · Sep 18, 2017 7:00AM

Summary

My requirement is replace all zeros with - sign

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

Venkat Thota - BIP · Sep 18, 2017 7:00AM

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

Jaswanth Elite · Sep 19, 2017 7:00AM

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 · Sep 19, 2017 7:00AM

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 · Sep 19, 2017 7:00AM

thanks for the help

Venkat Thota - BIP · Sep 19, 2017 7:00AM

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 '-'

OR

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

OR

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

still if you find issue , upload RTF and XML.

Jaswanth Elite · Sep 19, 2017 7:00AM

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

Thomas Dodds · Sep 19, 2017 7:00AM

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

Venkat Thota - BIP · Sep 19, 2017 7:00AM

upload rtf and xml , Thanks