AnsweredAssumed Answered

Formula not returning all intended components

Question asked by LennyGare on Jul 23, 2015
Latest reply on Jul 25, 2015 by philmodjunk

Title

Formula not returning all intended components

Post

The goal of this formula is to return a percentage for each investment for each investor of how much of the total invested in that series is.  Say Investor A has invested in Company A in Series A, B, C, and D.  It should provide me with the percentage of the total investment for each investment in each series. Currently the percentage showing up for every investment in each company is the same throughout the company. Even when the amounts invested in each individual series are different. For the most part these percentages are accurate to one of the series'.  Does anything stand out that I'm doing wrong?

 

If(S4_BVD Sub Series Number = 1 and S4_BVD Entity Name = S3_Investments::S3_Entity Name and 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 and S4_BVD Entity Name = S3_Investments::S3_Entity Name and 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 and S4_BVD Entity Name = S3_Investments::S3_Entity Name and 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 and S4_BVD Entity Name = S3_Investments::S3_Entity Name and 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 and S4_BVD Entity Name = S3_Investments::S3_Entity Name and 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 and S4_BVD Entity Name = S3_Investments::S3_Entity Name and 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 and S4_BVD Entity Name = S3_Investments::S3_Entity Name and 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; "" )

Outcomes