Simple question for PP Pros - Calculated Column using two tables

[Badrul]

This should be simple yet whatever I try doesn't seem to work.

FactTable:[TABLE="width: 500"]
<tbody>[TR]
[TD]accountRowID[/TD]
[/TR]
[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]


AccountRollup:[TABLE="width: 500"]
<tbody>[TR]
[TD]mapping[/TD]
[TD]accountRowID[/TD]
[TD]sign[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]-1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[TD]-1[/TD]
[/TR]
</tbody>[/TABLE]

What would be the formula for a calculated column in my fact table that returns the correct sign for my account.
I am ok with using a Max([Sign]) because the sign will remain for anything that has the same accountRowID (irrespective on the 'mapping').

Please help!

 

[Badrul]

Actually I just realized my problem is harder than that.

I'll have to create an new post for it and will see if I can cancel this post.