Cost mapping to newly created fields

[rrrggg20]

Hello all, 

I have a question about mapping costs for a project to dynamic fields and placing them in the correct cells.

The scenario is:

there are multiple projects, whose phases are determined by the milestone dates within the activities of the project

The costs are estimated by multiple people

The problem is I need to roll these costs up by they cost type (dynamic) then put them in the year month that they fall in the project.

I have the project phases created and costs loaded, I am trying to do something like this (in variables)

The costs would come in from Dept1, Dept2, Dept3.

I am trying to map Dept1 and Dept2 to COSTTYPE1 and Dept2 to COSTTYPE2

Something like this

(This is in Variables, not a load script.)

I have tried vExternal =:

if(COSTSOURCE = 'Dept1' OR COSTSOURCE = 'Dept3', $(Cost))

if(COSTSOURCE = 'Dept1' OR COSTSOURCE = 'Dept3', Cost)

vExternal = if(COSTSOURCE = 'Dept1' OR COSTSOURCE = 'Dept3',sum(Cost)) 

any help is appreciated

However the cost is not coming through.

I have tried if(COSTSOURCE = 'Dept1',$(Cost))

[rrrggg20 · Accepted solution]

stupid typo, I found it.