Forum Discussion

davis_dai's avatar
davis_dai
New Member
6 years ago

related() issue

Normal : revenue_BU = [revenue]/related(Rate[Exchange Rate]) in the case [Exchange Rate]=6.95

But Line 1:  [revneue_Bu]= 603,668.6 / 6.95=86,858.79 <> 99,669.2 (calculate [Exchange Rate]=6.05672164 not equal 6.95)

Line 2  also mistake.

Line 3 to line 6 is correct

anyone face this issue. and how to solution.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

    Can you try creating a new column with the IF Statement that you have and then use the SUM function. If the Related Function does not seem to work, you would need to make sure that the relationship should be properly configured between the Columns of the two tables.

     

    Best Regards,
    Vignesh M

    If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂