Populating the currenty and amount

[SH_94]

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.

Many thanks for the support.

[SH_94]

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.

Many thanks for the support.

[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 · Accepted solution]

@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:

[binu_acs]

@SH_94 Another approach