BI Publisher (MOSC)

MOSC Banner

How to use Format-number finction with if else condition in rtf

edited Jun 28, 2013 3:44AM in BI Publisher (MOSC) 10 commentsAnswered ✓
Hello All,

I have a requirement to display the number value in + or -ve format. So If I use below condition then it display all the values(including -ve values) in +v manner.

<?format-number(CF_TOTAL,"### ,###.00")?> 

So Now I want to try it with if else condition.

Could you plz guide me if below condition is correct or not?

<?xdofx:if CF_TOTAL>0 then <?format-number(:CF_TOTAL,"### ,###.00")?> elsif <?format-number(:CF_TOTAL,"-### ,###.00")?> end if?>

Thanks,

Joohi

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