Reply
Highlighted
Community Support Team
Posts: 1,332
Registered: ‎07-30-2018

Re: Need help with column calculation

HI, @Nilanka

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.