Hello,
I request assistance with performing calculations utilizing crosstabs successful Crystal Reports.
This Gross Margin astatine the bottom is the calculated member
this is the look that is utilized to budget
GridValueAt(GetIndexOf("Command.U_Sub","Sales"), CurrentColumnIndex, CurrentSummaryIndex)-
GridValueAt(GetIndexOf("Command.U_Sub","Cost of Raw Materials"), CurrentColumnIndex, CurrentSummaryIndex)
this is the look that is utilized to cipher full Actual
GridValueAt(GetIndexOf("Command.U_Sub","Sales"), CurrentColumnIndex, CurrentSummaryIndex)-
GridValueAt(GetIndexOf("Command.U_Sub","Cost of Raw Materials"), CurrentColumnIndex, CurrentSummaryIndex)
this is the look that is utilized to cipher full Variance
GridValueAt(GetIndexOf("Command.U_Sub","Sales"), CurrentColumnIndex, CurrentSummaryIndex)-
GridValueAt(GetIndexOf("Command.U_Sub","Cost of Raw Materials"), CurrentColumnIndex, CurrentSummaryIndex)
Now I privation to cipher the full variance% by dividing the full variance by the full fund value.
(259,160.47)/455,926.85=(0.57).How tin I bash this?