phesson Member

Comments

  • Thank you, how do I do that. Are you saying beastmode formulas can color rows? I didn't think there was a rank function, so the first column is simply the same data as the last column, just displayed as "ranked highest to lowest".
    in Card Color Options Comment by phesson February 14
  • Yes, QTY is showing up as a measure. Also, I don't necessarily need to sum these I guess, I just didn't know how to have this column display the QTY based on what source is selected. I believe in the other dataset this is already summed up and displayed by transaction.
    in Filter Column Data By Value Comment by phesson November 2023
  • Yes, same thing
    in Filter Column Data By Value Comment by phesson November 2023
  • Removed, still that pesky error.
    in Filter Column Data By Value Comment by phesson November 2023
  • SUM(CASE WHEN Source = 'POS' THEN sum(Qty) ELSE 0 END) CASE WHEN Source = 'POS' THEN sum(Qty) ELSE 0 END Tried these two. There are two columns I'm needing to sum and was going to do a calc for each one. Qty & Total (one is quantity of product sold, other is price of product sold). Thanks
    in Filter Column Data By Value Comment by phesson November 2023
  • Thank you for all the replies!! I was on the right track with this, but I'm still getting this error when trying to save the Beastmode calc using the examples above and updating to my data. This is the error I get, can't find any info on why it is throwing.
    in Filter Column Data By Value Comment by phesson November 2023
Default Avatar