What's new in Customer Journeys?

Connect and learn more!
Can I use substr on account.all in UDF in SLA? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can I use substr on account.all in UDF in SLA?


We are trying to use a user-defined formula to get value of an individual segment (which is not defined in as one of the segments like "Intercompany Segment" etc) from the revenue account.

The code that we wrote was :

Substring("Bill-to Site Use Revenue Account"."All",32,4)

For some reason it does not seem to be pulling the expected value.

However, if we try to use a segment labelled as "Intercompany Segment" instead of "All", it does seem to work.

For example, "Bill-to Site Use Revenue Account"."Intercompany Segment"

Does anyone have an experience with using Substr on Account.All kind of source?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!