Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

calculate currency

"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 a...
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]
        )
    )
)

     

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity 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]
        )
    )
)