Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Formula - Expression - If Statement

  1. #1
    Join Date
    Sep 2012
    Posts
    25

    Default Formula - Expression - If Statement

    Hi,

    i am trying to write the below If statement in the formula step and i get invalid argument error. can you please validate and let me know what i am doing wrong here? Thanks for your help

    IF ([FROM_CURRENCY_CODE]= "USD"; [LOCAL_CCY_CODE] ;
    IF ([FROM_CURRENCY_CODE] = "EUR" ; IF ([LOCAL_CCY_CODE] = "USD" ; "EUR"; [LOCAL_CCY_CODE]) ;
    IF ([FROM_CURRENCY_CODE] = "GBP" ; IF ([LOCAL_CCY_CODE] = "USD" ; "GBP" ; IF ([LOCAL_CCY_CODE] = "EUR" ; "GBP" ; [LOCAL_CCY_CODE] ) )
    ;[FROM_CURRENCY_CODE] )))

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Wouldn't it be a much better way to put the conversion pairs into a Grid and use a Stream Lookup?
    So long, and thanks for all the fish.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.