Populating the currenty and amount

Hi community,

I would like to ask how to populate the currrency and value for the below set of example data if i have mulitple currency and value as below.

The allocating the currency type will be based on the company code and type of currency.

Screenshot 2023-12-29 104239.png

Many thanks for the support.

Excel Input.xlsx

Common Use Cases

Accepted answers

CoG

@WeiLi- is absolutely correct for the last 3 columns, the first three will require summarizing and joining the data to achieve the full desired result:

Sample Workflow.yxmd

All comments

WeiLi

Why not just use the formula tool?

Add 3 columns using the formula, called [LCC Currency Amount], repeat for GCC and HCC

[LCC Currency Amount]

IF [Currency Type] = 10 THEN [Currency Type] ELSE 0 ENDIF

[GCC Currency Amount]

IF [Currency Type] = 20 THEN [Currency Type] ELSE 0 ENDIF

[HCC Currency Amount]

IF [Currency Type] = 30 OR [Currency Type] = 50 THEN [Currency Type] ELSE 0 ENDIF

CoG

@WeiLi- is absolutely correct for the last 3 columns, the first three will require summarizing and joining the data to achieve the full desired result:

Sample Workflow.yxmd

binu_acs

@SH_94 Another approach

Currency_Amount_291223.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335