Actual Sales vs Sales Budget

[#1]

Hi guys

I have a QV Sales model & I also have a Sales Budget that was done in Excel. I don't know how to add the budget to this model without having loops etc.

I am attaching the table viewer that shows the Sales QV Model as it is at the moment. You will also see that there is a seperate Budget table in the table viewer (this is the excel file I mentioned). I have added "%" infront of every field so that it do not create loops etc.

I need to link that budget to the indicated fields if possible.

If someone could advise I would appreciate it alot.

[sparur]

Hello

I advice you to join budgetAmount into your Sales table. So you no need to change model

[#3]

Thanks for the reply. So you say I must join BudgetSalesAmount into my INVOICE table. What join will I be using?

Regads

[sparur]

I tnink

LEFT JOIN(INVOICE)

LOAD

....

RESIDENT Budget;

[#5]

On what field will this then join as there is no field that is the same?

[sparur]

no same fields ? that's strange. Usually, the main task is comparing budget and Sales amount.

so you should have several same fields, for example: TransDate, Customer, Item etc...