cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chellamotte Frequent Visitor
Frequent Visitor

Problem comparing actuals (in revenue per invoice for a month) vs budget ( 1 total per month)

Hi,

 

I am currently trying to make comparison KPI's to followup monthly actuals vs the monthly budget I calculated.

 

The actuals are one line per invoice (per customer), which I divided in months using a splicer.

But my problem lies in the budget, which is just an excel sheet with the month and the total for that specific month.

 

Every time I use the monthly budget, it keeps using the total value of the entire year, which isn't what I am looking for.

 

Any suggestions on what I would be doing wrong?

 

Thanks in advance!

1 REPLY 1
Dan80 Regular Visitor
Regular Visitor

Re: Problem comparing actuals (in revenue per invoice for a month) vs budget ( 1 total per month)

Are you using a date table which is linked to both the actuals and budget tables?