AnsweredAssumed Answered

Issue with GetValue/GetField functions

Question asked by lbl159 on Sep 16, 2015
Latest reply on Sep 16, 2015 by lbl159

Below is my function. The Series Order Distribution portion has many other parts, but I didn't include them here because of length. It is highlighting S3_Liquidation Preference Value 1 saying that an operator is expected here. Any ideas on how to fix this formula?

 

I am trying to reorder information based on the Financing Round (of which I have 1-10).  Basically saying if the Financing Round Order is 1 then take the value from S3_Liquidation Preference Value 1, if the Financing Round Order is 2 then take the value from S3_Liquidation Preference Value 2

 

 

Let([

 

Series Order Distribution =

If ( S3_Investments_Entities::S3_Financing Round Order 1 = S3_Investments_Entities::S3_Financing Round 1 ; 1 ) &

If ( S3_Investments_Entities::S3_Financing Round Order 2 = S3_Investments_Entities::S3_Financing Round 1 ; 1 ) &

If ( S3_Investments_Entities::S3_Financing Round Order 3 = S3_Investments_Entities::S3_Financing Round 1 ; 1 ) &

If ( S3_Investments_Entities::S3_Financing Round Order 4 = S3_Investments_Entities::S3_Financing Round 1 ; 1 ) &

If ( S3_Investments_Entities::S3_Financing Round Order 5 = S3_Investments_Entities::S3_Financing Round 1 ; 1 ) &

If ( S3_Investments_Entities::S3_Financing Round Order 6 = S3_Investments_Entities::S3_Financing Round 1 ; 1 ) &

If ( S3_Investments_Entities::S3_Financing Round Order 7 = S3_Investments_Entities::S3_Financing Round 1 ; 1 ) &

If ( S3_Investments_Entities::S3_Financing Round Order 8 = S3_Investments_Entities::S3_Financing Round 1 ; 1 ) &

If ( S3_Investments_Entities::S3_Financing Round Order 9 = S3_Investments_Entities::S3_Financing Round 1 ; 1 ) &

If ( S3_Investments_Entities::S3_Financing Round Order 10 = S3_Investments_Entities::S3_Financing Round 1 ; 1 );

 

result =

GetValue ( "GetField ( "S3_Investments::S3_Liquidation Preference Value 1" )

GetField ( "S3_Investments::S3_Liquidation Preference Value 2" )

GetField ( "S3_Investments::S3_Liquidation Preference Value 3" )

GetField ( "S3_Investments::S3_Liquidation Preference Value 4" )

GetField ( "S3_Investments::S3_Liquidation Preference Value 5" )

GetField ( "S3_Investments::S3_Liquidation Preference Value 6" )

GetField ( "S3_Investments::S3_Liquidation Preference Value 7" ) "

; Series Order Distribution )] ; result )

Outcomes