Complex Bucket/Variable

37 Views

I have a column in my report called: [Var_MM Lead Time Indicator] which gives result in rows like: A, B, C, D, E and F. Now I need to calculate the numbers of A, B, C, D, E

and F for every section and for the entire report.

The result should look something like: A=32 B=31 C=0 D=10 E=5 F=100 on the top of every section and below the header of the report.

I have created [Var_MM Lead Time Indicator] as

=If ([Var_MM Lead Time vs Actual]<-60) Then "A" ElseIf([Var_MM Lead Time vs Actual] Between(-60;-30))

Then "B" ElseIf([Var_MM Lead Time vs Actual] Between(-30;0))

Then "C" ElseIf([Var_MM Lead Time vs Actual] Between(0;30)) Then "D"

ElseIf([Var_MM Lead Time vs Actual] Between(30;60)) Then "E" Else "F"

AND

[Var_MM Lead Time vs Actual] as

=[PO Create to GR]-[MM Lead TIme]

Please advise.