Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need help with column calculation

I have two columns Package price and Currency. In the Currency column i have 3 difference currencies present NOK , DKK and EUR. I want the DKK  values from Package price  to multiplied by 1.28 and...
General Comment
Need Help
Show and Tell
themistoklis's avatar
themistoklis
Community Champion
7 years ago

You can also use an if statement:

 

Measure = IF([Currency] = "EUR", 9.54 * [Package_Price], IF([Currency] = "DKK", 1.28 * [Package_Price], [Package_Price]))
Anonymous's avatar
Anonymous
Not applicable
7 years ago

"Operator or expression '( )' is not supported in this context."

 

i got this as a reply , what is my mistake here

  • affan's avatar
    affan
    Solution Sage
    7 years ago
    Which solution have you tried from the above ones?
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Currently trying all , but struggling to get the outcome I want. Will be trying it again , i must have made a mistake somewhere

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    HI, Anonymous

    Try this formula to add a calculate column

    New Package Price = 
IF (
    [Currency] = "EUR",
    9.54 * [Package Price],
    IF (
        [Currency] = "DKK",
        1.28 * [Package Price],
        IF ( [Currency] = "NOK", [Package Price] )
    )
)

    16

     

    Best Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I am still not able to calculate it this is the error i get

       

      • themistoklis's avatar
        themistoklis
        Community Champion
        7 years ago

        Change the last VoucherLog[Currency] to VoucherLog[Package Price]