BI Publisher (MOSC)

MOSC Banner

Want to put thousand separator, but below code giving NULL value in RTF template

edited Feb 8, 2023 5:31PM in BI Publisher (MOSC) 4 commentsAnswered

Want to put thousand separator, but below code giving NULL value in RTF template

<?xdofx:if L1_NAME in (' GB Primary ',' IE Primary ') then

(

if L1_METRIC in('Total Value of AR Transactions','Value of AR On-Account)  

then 

format-number(L1_QUARTER_4,"###,###.00")

else

L1_QUARTER_4)

else 

L1_QUARTER_4

?>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center