Forum Discussion
SUMX Row Values Incorrect vs Total
Hello digitalPlay , Can you please try using SUM instead of MAX if you have months in the row context. Let me know if it works.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Hello digitalPlay , please change the column data type for Overspend Flag. Values in it are in text select that column and in column tools select data type as whole number or decimal number depends on the data. Then this formula will work.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
thanks for that! however, if I put their groupings in the columns, it will show the overall total (which is correct) but the value and count will not be shown per group. If the ID has the same group month on month, it will show the values, however if it changes the next month, no value is picked up per group on that month but the total will still be correct. I guess groupby will help but my attempt to add it in the formula has failed.