Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Thank you for your help. Unfortunately I am still getting an error. The modified code is below. Any thoughts? It feels like the 'xdofx' and to_number is what is tripping me up... <?choose:?> <?xdofx:when: to_number(TOTAL_AMOUNT) > 25000?> <?call:jack?> <?end when?> <?end choose?>

in using 'call:' inside 'if' statement Comment by Kwujcik Jul 11, 2017 7:00AM
Brajesh, Thank you for the suggestion. I think the to_number is causing the issue here as well. Without 'xdofx' the code throws an error. If I add 'xdofx' back in, it appears to ignore the condition and always prints the <?call:jack?> image. Any thoughts?

in using 'call:' inside 'if' statement Comment by Kwujcik Jul 11, 2017 7:00AM