3. Is there something wrong with these if statements?

Is there something wrong with these if statements?

This is done in Filemaker Pro. It is providing me with one percentage value for every series. Is there an issue with the structure of these statements?

If(S4_BVD Sub Series Number = 1 & If( S4_BVD Entity Name = S3_Investments::S3_Entity Name & If( S4_Investment Date = S3_Investments::S3_Company Investment Date 1 ; "" ; "" ) ; "" ; "" ) ; S4_Investor_Entities 1::S4_Inv Amount 1 / S3_Investments::S3_Series Investment Total 1; "" ) & 
If(S4_BVD Sub Series Number = 2 & If( S4_BVD Entity Name = S3_Investments::S3_Entity Name & If( S4_Investment Date = S3_Investments::S3_Company Investment Date 2 ; "" ; "" ) ; "" ; "" ) ; S4_Investor_Entities 2::S4_Inv Amount 2 / S3_Investments::S3_Series Investment Total 2; "" ) & 
If(S4_BVD Sub Series Number = 3 & If( S4_BVD Entity Name = S3_Investments::S3_Entity Name & If( S4_Investment Date = S3_Investments::S3_Company Investment Date 3 ; "" ; "" ) ; "" ; "" ) ; S4_Investor_Entities 3::S4_Inv Amount 3 / S3_Investments::S3_Series Investment Total 3; "" ) & 
If(S4_BVD Sub Series Number = 4 & If( S4_BVD Entity Name = S3_Investments::S3_Entity Name & If( S4_Investment Date = S3_Investments::S3_Company Investment Date 4 ; "" ; "" ) ; "" ; "" ) ; S4_Investor_Entities 4::S4_Inv Amount 4 / S3_Investments::S3_Series Investment Total 4; "" ) & 
If(S4_BVD Sub Series Number = 5 & If( S4_BVD Entity Name = S3_Investments::S3_Entity Name & If( S4_Investment Date = S3_Investments::S3_Company Investment Date 5 ; "" ; "" ) ; "" ; "" ) ; S4_Investor_Entities 5::S4_Inv Amount 5 / S3_Investments::S3_Series Investment Total 5; "" ) & 
If(S4_BVD Sub Series Number = 6 & If( S4_BVD Entity Name = S3_Investments::S3_Entity Name & If( S4_Investment Date = S3_Investments::S3_Company Investment Date 6 ; "" ; "" ) ; "" ; "" ) ; S4_Investor_Entities 6::S4_Inv Amount 6 / S3_Investments::S3_Series Investment Total 6; "" ) & 
If(S4_BVD Sub Series Number = 7 & If( S4_BVD Entity Name = S3_Investments::S3_Entity Name & If( S4_Investment Date = S3_Investments::S3_Company Investment Date 7 ; "" ; "" ) ; "" ; "" ) ; S4_Investor_Entities 7::S4_Inv Amount 7 / S3_Investments::S3_Series Investment Total 7; "" )
/r/learnprogramming Thread
Previous
Next

Recently removed from /r/learnprogramming

"Self-taught" programmers - what was your learning route? Should I be testing this? IT/Tech courses are lacking with terrible Computer Science Professors and it's infuriating. JS - Multiple Outcome Comparisons HELP What got you your current job? What does it take to create a desktop environment or window manager? Should I keep trying to learn or will I never understand this? Is it cheating to use google to find tutorials to help complete CS assignments? Absolute beginner here, can I do this: To those transitioning into tech while struggling to make ends meet, how’d you do it? Teach Yourself Programming in Ten Years My First Python Programme - Without Use Following Along With a Guide Help? My teacher says to stay away from StackOverflow and other online help, is this good advice? How to Improve Logical Thinking?

More Random Comments

In the 1970s, archaeologists in Bulgaria unearthed a vast Copper Age necropolis from the 5th millennium BCE. Inside burial 43 they found the remains of a high status male with more gold than it was found in the entire rest of the world in that period. As a trans woman, I'm at my wits end being told to keep out of women's spaces. I want opinions from the women here. Hypertext Magic help needed Buy Modafinil Online Australia | Armodafinil For Sale – Coupon SAN -25$ Off Buy_Ox_Online I'm asking a question for the people who own a tortie Why should israel give up land or settle for peace? Why does it seem like dysphoric trans fems are a minority in trans fem spaces? Guest rooms Really need some help and advice from you guys. TW: Obesity there should be more christmas themed horror games Finally Friday! Meghan and history What do you guys do after you have a bad dream? (35M) (27F) Started dating a single mom of 5