Hello,
I've been experimenting with ALLEXCEPT and ALL and VALUES, and aren't quite sure what's happening, with 'excpept' it seems to see the entire data model and return the overall total regardless of the current filter context but with VALUES, the total is in the current filter context and i can't quite see why the difference occurs,
I've also found that ALLEXCEPT works for a running total with criteria, which means not having to declare a variable for the criteria and use an && .
Any help with understanding what's happening 'under the hood' or posts I should read welcome.
I've been experimenting with ALLEXCEPT and ALL and VALUES, and aren't quite sure what's happening, with 'excpept' it seems to see the entire data model and return the overall total regardless of the current filter context but with VALUES, the total is in the current filter context and i can't quite see why the difference occurs,
I've also found that ALLEXCEPT works for a running total with criteria, which means not having to declare a variable for the criteria and use an && .
Any help with understanding what's happening 'under the hood' or posts I should read welcome.