Variance amount is showing incorrect
Posted: Sun May 11, 2008 6:24 am
Hi Folks,
i have Defined FSG.
There are 5 Cloumns.
1. PTD-Actual
2. PTD-Budget
3. YTD-Actual
4. PTD-Variace (Budgeted - Actual)
5. Variance% (Variance/Budget*100)
I am unable to get Variance and Variance%
Could any one help me in this.
In column 4 i have taken calculations.
Budget clumn is 2 as Operator (+) and Actual PTD Column is 1 as Operator (-)
Eventhough it is not giving me the proper results.
For column 5 How could i get the results.
Give me some valuable ideas please.
Regards
Anjan
i have Defined FSG.
There are 5 Cloumns.
1. PTD-Actual
2. PTD-Budget
3. YTD-Actual
4. PTD-Variace (Budgeted - Actual)
5. Variance% (Variance/Budget*100)
I am unable to get Variance and Variance%
Could any one help me in this.
In column 4 i have taken calculations.
Budget clumn is 2 as Operator (+) and Actual PTD Column is 1 as Operator (-)
Eventhough it is not giving me the proper results.
For column 5 How could i get the results.
Give me some valuable ideas please.
Regards
Anjan