Expression returns NULL value

[alwinsch]

Hi all,

I have 2 tables:

• Projects: ID, project_name, profitA, profit,Chance_on_succes, leader
• Teamleader: leader, Leader_name

Now i want a table  with dimension Teamleader
and as expression sum(profitA + profitB)/chance_on_succes

The problem is if my teamleader has for every project the same chance_on_succes this works fine, but if he has multiple different chances, then we get no value returned.
how can we avoid this?

Kind Regards,

Alwin 

[alwinsch · Accepted solution]

Hi all,

I solved it myself.

Created extra columns in the projects table Chance_profitA, chance_profitB

Which is calculated from ProfitA and chance_on_succes.

This way it works fine for me.

kind regards,

Alwin

[Chanty4u]

please close this thread as correct.

Thanks

Suresh