0

# Calculate values based on Proportion in a cross tab report

Dec 01, 2016 at 10:50 PM

27

Former Member

Hello All,

I have a cross tab report that looks like this:

The fields “Quantity” and “Prod Hours” are manually entered fields while “Hours Worked” is a Summary and “Percentage” is an embedded Summary field

I have 4 Values on the cross tab report that I need to display using a custom formula as seen below:

Value 1 = 350 * 550/650 = 296.15 hours

Value 2 = 550 * 300 /650 = 253.84 hours

Value 3 = 350/Value 1 * 100 = 118.18 %

Value 4 = 300/Value 2 * 100 = 118.18%

As seen above Values 1 and 2 are calculated in proportion with the corresponding values above them of 350 and 300 respectively.

350 in proportion to 650 is 53.84% and hence Value 1 in proportion to 550 is also 53.84%

Similarly Just as 300 in proportion to 650 is 46.15%, Value 2 is also 46.15% in proportion to 550.

Will it be possible to write a customized formula that accomplishes the above scenario and automatically calculates Values 1, 2, 3 and 4 in my crosstab report?

Any advice will be greatly appreciated.

Thanks,

Nick

crosstab1.jpg (27.2 kB)
Former Member

Hello All,

Does anyone have any comments or Answers for the issue that I am facing above?