What's new in Customer Journeys?

Connect and learn more! ×
How to calculate data in multicolumn format - Data Management — 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

How to calculate data in multicolumn format - Data Management

Accepted answer
54
Views
6
Comments

Summary:

I want to calculate an amount column data in multi-column data rule.

Content (please ensure you mask any confidential information):

Hi,

How can I calculate an amount column based on other data columns?. I setup a multicolumn data rule. So, let say I have Acc1, Acc2, Acc3, Acc4 as data columns from Account dimension. Acc3 is the column to calculate (I assume I have to setup it as column in my csv as well)

What I want to do is:

==========================

CASE WHEN 'Acc1' is null THEN 'Acc4' = 0

 WHEN UD4 IN ('36071','36072','36073') THEN 'Acc4' = 'Acc2' // UD4 is another dimension column (Product)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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