calculate currency

[snifer]

"period amount	currency	source	change rate dkk actual	change rate dkk budget
1000	eur	actual	1	1.2
2000	sve	budget	2	1
3000	dkk	actual	100	100

this is how my data are stored

this is the result wanted

result in dkk	1000
	2000
	3000

my goal is to have everything in dkk

if the value is already in dkk just copy paste the amount

if values are different currency and based on "actual" source -> "period amount" change rate dkk actual"

if values are different currency and based on "budget" source -> "period amount" change rate dkk budget"

[themistoklis · Accepted solution]

@snifer

You can use an if statement in a new column

Calculated Column =
IF (
    Table[currency] = "dkk",
    Table[period amount],
    IF (
        Table[currency] <> "dkk"
            && Table[source] = "actual",
        Table[period amount] * Table[change rate dkk actual],
        IF (
            Table[currency] <> "dkk"
                && Table[source] = "budget",
            Table[period amount] * Table[change rate dkk budget]
        )
    )
)