BI Publisher (MOSC)

MOSC Banner

How to SUM a sequence on eText template

edited Sep 3, 2012 10:48PM in BI Publisher (MOSC) 2 commentsAnswered
Good day,I'm using an eText XML Template and I'm trying to calculate the Hash Total of to send produce a flat file for international payments. Part of the formula for the Hash Total involves doing a sum of the sequence number, multiplied by the sum of the branch numbers. Does anybody know what the syntax is it do a sum of the sequence number? I thought it would be as simple as
{code}SUM(SEQUENCE_NUMBER(DealSeqNumSC)){code} but my eText template doesn't like this.

This is how the sequence is defined on the template:
{code}

{code}

and this is how I'm trying to do the sum, but it doesn't work.

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