Forum Discussion

VictoriaCzar's avatar
VictoriaCzar
Frequent Visitor
3 years ago

Formula is applying a filter in everything

Hello everybody!!!   Im having problems to use a formula That I created,    Right down suppose to be the value of  [Zvalue per m3 transported] - [Agust]  in the column of ZTENTATIVA, but I'm not ...
Need Help
Show and Tell
VictoriaCzar's avatar
VictoriaCzar
Frequent Visitor
3 years ago

Hello!

 

Actually it didn't work, it just repeated the value from another column, I wanted to repeat just the value from august to others months so I can to the difference between July - august, September - august ... etc 

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

may we see your code for [Zvalue per m3 transported]?

  • VictoriaCzar's avatar
    VictoriaCzar
    Frequent Visitor
    3 years ago

    Yes 

     zvalue per m3 transported = divide(sum(acompanhamento[custo do containers]), sum([acompanhamento[stuffing]))*distinctcount(acompanhamento[containers])