BI Publisher (MOSC)

MOSC Banner

Sum of current group function is not working with if condition

edited Oct 21, 2020 12:09PM in BI Publisher (MOSC) 13 commentsAnswered ✓

I have a requirement to sum the total price based on item id.I have added group by function on item id and used the sum of current group function for summing the total price.But,I have if condition based on which I need to display the sum else other price.

Below code,I have written

<?xdofx:if xyz (field name) in ('a','b','c') 

then TOTAL_COST else sum(current-group()/EXTENDED_COST) end if?>

Please let me know what is wrong in this.


Thanks

Suchita

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