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
  • Anonymous's avatar
    Anonymous
    7 years ago

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

     

  • themistoklis's avatar
    themistoklis
    7 years ago

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

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

    HI, Anonymous

    There is a mistabke in your formula

    Column = IF(VoucherLog[Currency]="Eur",9.54*VoucherLog[Package Price],IF(VoucherLog[Currency]="DKK",1.28*VoucherLog[Package Price],IF(VoucherLog[Currency]="NOK",VoucherLog[Currency])))
     
    Column = IF(VoucherLog[Currency]="Eur",9.54*VoucherLog[Package Price],IF(VoucherLog[Currency]="DKK",1.28*VoucherLog[Package Price],IF(VoucherLog[Currency]="NOK",VoucherLog[Package Price])))
     
    Note: Black body part

     

    Best Regards,

    Lin

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

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]

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

      HI, Anonymous

      There is a mistabke in your formula

      Column = IF(VoucherLog[Currency]="Eur",9.54*VoucherLog[Package Price],IF(VoucherLog[Currency]="DKK",1.28*VoucherLog[Package Price],IF(VoucherLog[Currency]="NOK",VoucherLog[Currency])))
       
      Column = IF(VoucherLog[Currency]="Eur",9.54*VoucherLog[Package Price],IF(VoucherLog[Currency]="DKK",1.28*VoucherLog[Package Price],IF(VoucherLog[Currency]="NOK",VoucherLog[Package Price])))
       
      Note: Black body part

       

      Best Regards,

      Lin