I have an If formula where the 'value if false' is a field that is a calculation (S4_Investor_Entities 1::S4_FMV). Instead of returning just the correct number, it returns it repeating over and over again. Or sometimes it won't be exactly repeating and will look like: 17751057510575105751057510575106596.16 or 19612.519612.519612.519612.519612.519612.519612.5

As a test I added the field (S4_Investor_Entities 1::S4_FMV) to the layout on its own. That returned the correct values without any repetition. It is only when this field is being referred to as the 'value if false' in my If formula.

Any idea why this may be occurring?

Try something like this...

Let([

distribution = Case ( S4_BVD Sub Series Number = 1 and not IsEmpty (S3_Investments::S3_Net Distribution 1) ; S3_Investments::S3_Net Distribution 1 ;

S4_BVD Sub Series Number = 2 and not IsEmpty (S3_Investments::S3_Net Distribution 2) ; S3_Investments::S3_Net Distribution 2 ;

S4_BVD Sub Series Number = 3 and not IsEmpty (S3_Investments::S3_Net Distribution 3) ; S3_Investments::S3_Net Distribution 3 ;

S4_BVD Sub Series Number = 4 and not IsEmpty (S3_Investments::S3_Net Distribution 4) ; S3_Investments::S3_Net Distribution 4 ;

S4_BVD Sub Series Number = 5 ; not IsEmpty (S3_Investments::S3_Net Distribution 5 ) ; S3_Investments::S3_Net Distribution 5 ;

S4_BVD Sub Series Number = 6 and not IsEmpty (S3_Investments::S3_Net Distribution 6) ; S3_Investments::S3_Net Distribution 6 ;

S4_BVD Sub Series Number = 7 and not IsEmpty (S3_Investments::S3_Net Distribution 7) ; S3_Investments::S3_Net Distribution 7 );

result = If ( not isEmpty ( distribution) ; distribution * S4_Inv Total Percent FMV ; S4_Investor_Entities 1::S4_FMV )

];

result

)