CharlieDigital
Programmer
Hi, I'm trying to put together a custom rollup for a cube and having a hard time with it.
This image is a snapshot of the data in the cube that I'm working with.
As you can see, the default aggregation (sum) is being applied. My goal is to get the number in the blue box (with the gray background) to be equal to the cross product of the two arrays (vectors) in red divided by the number in green (the sum of the entries from the vector on the right).
So in this case:
Blue Box = [1.5 .4 .6] x [.02 .07 .07] / 2.5
or
Blue Box = (1.5*.02 + .4*.07 + .6*.07) / 2.5
Any assistance would be much appreciated.
This image is a snapshot of the data in the cube that I'm working with.
As you can see, the default aggregation (sum) is being applied. My goal is to get the number in the blue box (with the gray background) to be equal to the cross product of the two arrays (vectors) in red divided by the number in green (the sum of the entries from the vector on the right).
So in this case:
Blue Box = [1.5 .4 .6] x [.02 .07 .07] / 2.5
or
Blue Box = (1.5*.02 + .4*.07 + .6*.07) / 2.5
Any assistance would be much appreciated.