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
FreemanZ's avatar
FreemanZ
Super User
3 years ago

try this

Zvalue of august = 
[zvalue per m3 transported]-
calculate([zvalue per m3 transported], filter(all(calendar[month name]), dcalendar[month name] = "august")) 
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
    Super 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])