Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

calculate currency

"period amountcurrencysourcechange rate dkk actualchange rate dkk budget
1000euractual11.2
2000svebudget21
3000dkkactual100100

 

this is how my data are stored

this is the result wanted

result in dkk1000
 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"

Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    Anonymous

     

    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]
        )
    )
)

     

1 Reply

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

    Anonymous

     

    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]
        )
    )
)