first I apologize for asking something that has been already asked, I have search this forum but I cannot find my answer. My problem is that I have created a Key (concatenating Month & Year & DemandEntity) everything works my issue is when comparing Actual vs Budget, if there are no actuals I cannot find a way to display 0 and still show the budget for those months, I need to be able to display this on a graph, I need to show all months and a bar to show actuals and a line to show budget. I was able to create the graph but I cannot show budget for the entire year because I do not have sales for the future yet. How can I accomplish this?
Yes my Master Table contains a month and year field. I am looking into samples to create a master calendar. I appreciate your time and your help. I will start working on this and hopefully solve my problem.
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.
