Budget vs actuals

[#1]

dear friends,

i hope u r doing well i have following isssue

that is i have budget figures for sector wise  they have given summeraised values

now i want to convert that values for whole data and i want one gauge chart with speedo metre

like if i select month,year then budjet vs actual will reflect

i have samle data pls see the attchment

if u able to answer it would help me lot

Thanks&Regards,

chandu

[khadeer]

Hi RAM,

we didnt get any values in attached excel sheet, u have budget figures sector wise, what about actual values.

[#3]

Sorry,

Pls see the attachment

[#4]

This is my Requirement

For budget tracking, have a speedo chart on

     - The guage chart will show Actual
divded by Budget (%)

     - Chart will be green or red based on
budget figure pro-rated for no of days (for e.g. if we are looking at Dec end
figures, we will compare actuals with budget for nine months - which is total
budget / 12 multiplied by 9)

[khadeer]

How i can identify which r actual n which r budget.

[nirav_bhimani]

HI,

For distinguish between budget and actual you have to add field in the link table  budget data and transactional data (Actual Data). You have to create a link table for that.

Like

'Transaction' as Source, // In ur transaction link table

'Budget' as Source, // // In ur budget link table

Then with the help of this expression you can find the budget vs sales in gauge chart.

sum({<CalendarDate = {">=$(=num(Yearstart(max({<Source = {'Transaction'}>}CalendarDate),0,4)))<= $(=num(max({<Source = {'Transaction'}>}CalendarDate))) "},

CalendarWeekOfYear=,CalendarQuarter=,MonthName=,CalendarYear=>}Sales)

/

(sum(Budget))

Hope this will help you.

Regards,

Nirav Bhimani

[#7]

hai neerav

i have summeraised budjet for four sectors and acctuals for that four sector

now requirement is  i need to split that budget amount to all  calender selection

[nirav_bhimani]

Hi,

Please share the snapshot of that so that it would be more clear.

Regards,

Nirav Bhimani

[#9]

Hello Nirav Bhimani,

I like to analyse the Target and Current Revenue.Below is the scenario,

Current Revenue per month- 80,000

My target -1,00,000

Travelling Expenses-10,000

Electricity Charges -3000

Other Expenses    -1000.

My Questions is that:

I have a Gauge Chart where One end will display the Current Revenue and opposite will display the Target which I want to achieve.i have three slider control in which Travelling expenses amount,Electricity charges amount and Other Expenses amount are assigned.

If i decreases the Expenses in slider, then automatically my Current Revenue have to increases and

should moves to the target.How can i do this.Give me the code to do it.Please help me.