related() issue

davis_dai · ‎10-28-2019

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.

Anonymous · ‎10-28-2019

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 🙂