Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

user03817
user03817
Online

Badges

Badges
2

Accepted Solutions

Accepted Solutions
0

Likes

Likes
0

Posts

Posts
2

Discussions

Discussions
0

Questions

Questions
2

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by user03817
Customize the badges you want to showcase on your profile
Re: Functions - Rounding by intervals
Avatar
Give Back
Level 1
user03817
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
View profile
user03817
- Adobe Campaign Standard
Hi Ramon,Thanks for the response. What if the field type is text? The data is being queried from a custom ACS Table and is being sent from PEGA. It's also an eVar field and plans are to apply the function through an enrichment activity.I tried using the the Ceil but received the error belowPGS-220000 PostgreSQL error: ERROR: operator does not exist: character varying / integer LINE 1: ...alia/Canberra' AS date), Ceil(C1.sAddressPostcode / 1000) * ... ^ HINT: No operator matches the given name an...

Views

74

Likes

0

Replies

1
Functions - Rounding by intervals
Avatar
Give Back
Level 1
user03817
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
View profile
user03817
- Adobe Campaign Standard
Hi there,I was just wondering how you would go about rounding in intervals through functions?For example - If number is between 0-10, round as 10, 10-20 as 20, 20-30 as 30.Cheers,Mo

Views

94

Likes

0

Replies

3