9 Replies Latest reply: Jul 18, 2015 11:07 AM by Iñigo Elviro Bodoy

# SUM VARIABLES IN VARIABLE OVERVIEW

Hi everybody:

I am trying to do a sum of variables in variable overview and only calculate the first one:

The variables are:

vManoObraIndirectaResto= Sum({<[TASAS HORARIAS]={"Mano obra indirecta (resto):"}>} [€/hora activa de trabajo])/\$(vProductividadProduccion)

If I insert them in individuals columns like  (=\$(vManoObraDirecta)) it works well.

But the problem is when I try to do a sum of the two variables in the variable overview:

only calculate the first of them: \$(vManoObraDirecta).

If I change the position: \$(vManoObraIndirectaResto)+\$(vManoObraDirecta) calculate the other but doesn´t sum the second.

Any idea?

• ###### Re: SUM VARIABLES IN VARIABLE OVERVIEW

may be you are missing to Put "=" sign before \$(vManoObraIndirectaResto)+\$(vManoObraDirecta)

• ###### Re: SUM VARIABLES IN VARIABLE OVERVIEW

I am not sure of the definition of vProductividadProduccion, but I would add these two like this:

RangeSum handles the case where one of the expressions is null.

• ###### Re: SUM VARIABLES IN VARIABLE OVERVIEW

Hi Jonathan:

The two solutions doesn´t work.

The formul of the productivity is a very long expression:

if([Nº of plies (nº)]=2,if(([Metros /Min]/(Avg([Sheet lenght (mm)])*Avg([Nº of sheets (nº)])/1000))>[Barras / Min],

[Barras / Min]*(Floor(2750/Avg([Width sheet  (mm)])))*0.7*60, [Metros /Min]/(Avg([Sheet lenght (mm)])*Avg([Nº of sheets (nº)])/1000)*(Floor(2750/Avg([Width sheet  (mm)])))*0.7*60),if(([Metros /Min]/(Avg([Sheet lenght (mm)])*Avg([Nº of sheets (nº)])/1000))>[Barras / Min], [Barras / Min]*(Floor(2750/Avg([Width sheet  (mm)])))*0.7*60*7/8, [Metros /Min]/(Avg([Sheet lenght (mm)])*Avg([Nº of sheets (nº)])/1000)*(Floor(2750/Avg([Width sheet  (mm)])))*0.7*60*7/8))

It is very strange that only the first variable is well calculated.

• ###### Re: SUM VARIABLES IN VARIABLE OVERVIEW

Change the double quotes into single quotes, and/or try this:

Sum({<[TASAS HORARIAS]={'Mano obra directa:', 'Mano obra indirecta (resto):'}>} [€/hora activa de trabajo])/ (\$(vProductividadProduccion))

If that works, and you want it in a variable, then you can create a single variable.

• ###### Re: SUM VARIABLES IN VARIABLE OVERVIEW

Hi Jonathan:

At the end this option is correct but I would have prefer to make work the expression like sum of variables.

Anyway, thank you.

• ###### Re: SUM VARIABLES IN VARIABLE OVERVIEW

did try wrapping the variable in num#(\$(vManoObraDirecta),'#,##0.# ')?

• ###### Re: SUM VARIABLES IN VARIABLE OVERVIEW

You could may be try

vManoObraDirecta=Sum({<[TASAS HORARIAS]={"Mano obra directa:"}>} [€/hora activa de trabajo])

vManoObraIndirectaResto= Sum({<[TASAS HORARIAS]={"Mano obra indirecta (resto):"}>} [€/hora activa de trabajo])

• ###### Re: SUM VARIABLES IN VARIABLE OVERVIEW

Hi Sasidhar:

Really, this is the correct solution.

It works well.

Thank you.