Key and calculated field

[#1]

HI,

I need to make a comparison between the actual sales and the sales budget.

in the Budget tab I createda calculated field:    Month(budgetMont) as Budget_Month it dosnt work from some rason.

And the second field I created is key field : BudgetYear&'-'&Budget_Month&'-'&CategoryID as KeyCompare .

The goal is to link the budget table and the sales table.-

In Sales tab I created:  Year&'-'&Month&'-'&CategoryID as KeyCompare

I created twice, once in sales table and once in SalesHistoty table.

What is the problem? whay it dosnt work?

Also, how can I create a calculated field  in sales tab?

Example: QTY * COST

[Clever_Anjos]

1) Month(budgetMont) as Budget_Month,  Month function requires a date, you´re using a string "Jan", "Feb"

2) BudgetYear&'-'&Budget_Month&'-'&CategoryID I´d like to see you data Budget.xls

3) Year&'-'&Month&'-'&CategoryID as KeyCompare, I don´t see a field called Month and Year, maybe you´re talking about Month(Date), Year(Date)

[Clever_Anjos]

QTY * COST, you can calculate after the "left join"

Left join (Sales)

LOAD

ProductID,

Date,

QTY * COST as AFieldName

resident Sales

[#4]

Thanks for your response.

Can you attach your answer with a QVD FILE?

[Clever_Anjos]

It would be easier if you send me sample of your data

[#6]

You mean I'll send you the Excel files?

There is an option to send it in private message?

[Clever_Anjos]

yes, send to clever@clever.com.br

[#8]

I sent you an email