What's new in Customer Journeys?

Connect and learn more! ×
Calculate amount in multicolumn file - 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

Calculate amount in multicolumn file - Data Management

Accepted answer
31
Views
2
Comments
edited Jan 29, 2024 5:51PM in Planning 2 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!