I want to do calculation row wise but it comes from different tables

[dshah12]

I want to do 3+5-2 =6 for id 1 specifically. But here actual amount comes from different table  whereas forecast and recommended from same table

Please help 

id	actual amount	forecast amount	recom amount
1	3	5	2
2	2	3	5

[Arul]

@dshah12 ,

Does the table which is having actual is also having id?

Are you want to calculate this as a measure?

Can you provide the meta data/some sample data?

Thanks,

Arul

[dshah12]

Actual amount does not have id .The id is available for this both and is coming from same table 

amount

forecast amount

recom amount

[Arul]

@dshah12 ,

Without id how can we identify which actual value belongs to whic row for the other table forecast and other columns?

Thanks,

Arul

[dshah12]

I have created relationship in that way I take id for that particular table

[Arul · Accepted solution]

@dshah12 
Can you share what is the relationship key between two tables?

Thanks,

Arul