
Re: Problem Operation with Variables
Sunny Talwar Oct 4, 2016 7:05 PM (in response to Iñigo Elviro Bodoy)May be remove this parenthesis > $((V1)/($(V2)*480)
$(V1)/($(V2)*480)

Re: Problem Operation with Variables
Iñigo Elviro Bodoy Oct 5, 2016 2:25 AM (in response to Iñigo Elviro Bodoy)Sorry, it does not work.

Re: Problem Operation with Variables
Marcus Sommer Oct 5, 2016 2:47 AM (in response to Iñigo Elviro Bodoy)Do you mean with it doesn't work that the result isn't like you expected it or that you yet get an errormessages? I think you should be more explicit by declaring the variables to ensure that your calculations happens in the right order. I mean something like this:
V1:
(Sum({<Linea={"1"}, Codes={"*"}{"1","20","24","31"}>} Quantity)/60)
V2:
(Count (distinct {<Linea={"1"},Codes={"*"}>}Clave)(Sum ({<Linea={"1"},Codes={"1","20","24","31"}>} Quantity/60)/480))
and then use these variablecalculations within a tablechart without an expressionname so that you could see within the expressionlabel how the variables will be evaluated (in cases of memory exceeded reduce the dataset by removing dimensions and selecting to a quite granular level).
 Marcus

Re: Problem Operation with Variables
Iñigo Elviro Bodoy Oct 6, 2016 11:52 AM (in response to Marcus Sommer )Hi Marcus:
Sorry for the not clear message.
At the end the solution was other:
1/480 *$(V1)/($(V2)
I don´t know why if I insert the value at the beginning of the expresion it works.
Best regards,



Re: Problem Operation with Variables
Peter Cammaert Oct 6, 2016 11:57 AM (in response to Iñigo Elviro Bodoy)If V2 contains an expression that divides by 480, and in your final expression you multiply by 480, can't you just leave out the division/multiplication?

Re: Problem Operation with Variables
Sunny Talwar Oct 6, 2016 11:58 AM (in response to Peter Cammaert )
