Forum Discussion
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 finding a way to do this, especially because my formula of
Zvalue of august = calculate([zvalue per m3 transported], filter(all(calendar[month name]), dcalendar[month name] = "august"))
is filtering the ZTENTATIVA and only doing the difference in the month of august
Please can someone help, i think is simple but I'm not understanding how to do it
4 Replies
FreemanZSuper User
try this
Zvalue of august =[zvalue per m3 transported]-calculate([zvalue per m3 transported], filter(all(calendar[month name]), dcalendar[month name] = "august"))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
may we see your code for [Zvalue per m3 transported]?
