How to mulitply a value held in a column based on a value in a table

[paul_ripley]

Hello

 If you see on my attachment, I have a table 'Central Allocations' What i would like to do for example is multiply the values in the 'Infra' column by the value in the 'Central Allocations' table and put on the correct line. For example I would want to mulitply 'Finance Tax and Treasury' (the team_description) by 0.5 ie 567,729 * 0.5 and put in the Core column (as the value in Core_alloc is 0.5).

To make it simple i was just going to mulitply to 'Infra' column by the value per team 

Infra*(sum({$ <infra_central_allocs = {team_description} >} Core_alloc))

Could you please help with this as I am obviously doing something wrong

Thanks

Paul

[Arthur_Fong]

Try:

sum(Infra)*(sum({$ <infra_central_allocs = {team_description} >} Core_alloc))

[paul_ripley]

Hi Arthur

Thanks but it came back with Bad filed name Infra

I tried to replace the 'Infra' with the expression in the Infra column but that didnt work either

Thanks

Paul