Calculated member in cross tab report

1 month ago 11

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?