match function

[#1]

Hi,

I am stuck in one logic,please help me to resolve that issue.

I have two fact table which are link to each other with the help of key,some rows are not mapped due to key are missing in one table.

I want sales of those employee whose key are matched with each table.

Thanks in advance.

Regards,

Nisha

[PradeepReddy]

try this expression....

=sum(if(not IsNull(Sales1) and not isnull(Sales), Sales1))

Note: I am assuming the values of 'Sales' and 'Sales1' for each key is same.

Thanks,

Pradeep

[Anonymous]

Hi,

Try something like below,

Sum ({$<[Employee Name]={"*"}>} Sales1)