Account Range in UC Formula

[bburbage]

I am currently using the Universal Connector with Oracle. Our Chart of Accounts structure is less than desirable. I am trying to get a sum of certain GL accounts without having to sum the data on another spreadsheet and referencing it. I have tried giving the column a named range which has worked for me in the past with a list of single account numbers, but I get a 0 result when using it with a column of account number ranges. My function and column data are below. Can someone help? Can this be done?

=NL("Sum","XXALF_GL_BALANCES_V","PTD","ACCOUNT",NamedRange1,"CURRENCY_CODE","USD","PERIOD_NAME",$J$2)

NamedRange1 Column of account numbers
40011..40015
40017..40017
40035..40049
41922..42299
45100..45104
45200..45204
45300..45304
45400..45404
45500..46299
49925..49925
50037..50039
50090..50109
55300..55399
56300..56319

[shermang]

You might try NP("Join") with an OR "|"

For example

Code: Select all

=NL("Sum","XXALF_GL_BALANCES_V","PTD","ACCOUNT",NP("Join",NamedRange1,"|"),"CURRENCY_CODE","USD","PERIOD_NAME",$J$2)