Forum Discussion
Calculated Column
Hi, Based on the following diagram, I want to create the next calculated column, value, in the table INDICATOR based on two metrics and one variable: value=(deliveries/planedDeliveries)*...
Anonymous you have to add these as measures, not columns.
parry2k thanks for the reply, but as i said above i already tried with measures (metrics):
value=(deliveries/planedDeliveries)*weight
metrics (measures):
mDeliveries = sum(deliverie)
mPlanedDeliveries = sum(planedDeliverie)
but i'm not getting the correct values...
I have to get all the INDICATOR values in the column value to do other further calculations based on that column.
As i said the problem is with the measure mPlanedDeliveries = sum(planedDeliverie) that is not giving the correct values in each row of the INDICATOR table.
Do you know or have an idea why?