BI Publisher (MOSC)

MOSC Banner

Issue with using SUM & DECODE together in etext template while generating payment format outputs

edited Aug 27, 2020 1:20PM in BI Publisher (MOSC) 20 commentsAnswered

I am trying to use Sum & Decode functions in etext template as follows

SUM(DECODE(DocumentPayableLine/LineType/Code,‘ITEM’,0,

DocumentPayableLine/ LineGrossAmount/Value))

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