Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have 2 tables:
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
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
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
please close this thread as correct.
Thanks
Suresh