Calculate amount in multicolumn file - Data Management

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)