two formulas with the same field, but one returns a #ref

[ammartino44]

Hello. I have these two formulas (I think for Powerpivot) The first one works fine, but the second one returns a #ref error for [Measures]. How could one work and not the other? Thanks.

1) =GETPIVOTDATA("[Measures].[Sum of Trade Cost]",$B$7)/GETPIVOTDATA("[Measures].[Distinct Count of Contract ID2]",$B$7)

2) =(GETPIVOTDATA("[Measures].[Distinct Count of ClaimID]",$B$7)*56.4)/GETPIVOTDATA("[Measures].[Distinct Count of Contract ID2]",$B$7)

[jcaynes]

It looks like there is an extra open paren at the beginning? =(GETPIVOTDATA for number 2, where it should be like number 1, and only the open paren following the GETPIVOTDATA.