Hi,

I've created a group that shows my Campaigns and would like to add the total cost of each campaign to the List view layout.  I dropped "Campaign.Actualcost" into the layout in the Query builder, because that sounded like the field I was looking for.  It is either not the right field, or I'm doing something else wrong, because the field is blank for all my campaigns, though I have plenty of costs listed for each. 

Then I tried "Campaign.Expensesactual" because that also sounded like it could be the right field, but this also showed an empty field.  I set the Format to Currency.  This didn't help.

FinalIy I tried dropping in "Campaign.Campaigntask.Actualcost" into the layout, but this lists eash task cost separately for each campaign rather than the total cost for the campaign. So rather than each of my campaigns being listed once with the total cost, each campaign is listed multiple times - once for each task cost.

Any suggestions?  What am I doing wrong?

Thanks,

Kim

Unfortunately, the ActualCost field does not get populated in the LAN version of the Marketing module, by default.  The value you see on the screen in the Budget Results tab (Actual Task Costs) is calculated by running a SQL query to sum all of the task costs.

You could modify the Budget Results tab and bind the field to the CAMPAIGN.ACTUALCOST.  That way when the screen opens and the total is calculated it would populate the field and make it available for use in the groups. 

This is kind of a pain but is unfortunately the only way.  Either that or you could build a SQL view with the data you need, enable the view in the SLX administrator, and then create a group off the view.