user031733 Member

Comments

  • Grant, you might need to clarify your question, but I think I get the gist of what you're asking. I am trying to get a count of the # of contacts that have revenue greater than 100k. So it's a number of contacts I am looking for. Eventually, I want to do a % of total contacts, but need to take the first step. @jaeW_at_Onyx…
    in Unique Count based on Revenue Amount Comment by user031733 June 2022
  • @jaeW_at_Onyx wrote:@Cartergan Case when `Department Name` = "Revenue" then ABS(`Transaction Currency Amount`) End By using double quotes, ", around Revenue, it's interpreting it as a column name instead of text. I believe you meant: Case when `Department Name` = 'Revenue' then ABS(`Transaction Currency Amount`) End…
    in Beast Mode - Revenue from a negative to a positive Comment by user031733 May 2020
  • @Cartergan wrote:It seems you may need to include a Case statement into the beast mode since you are checking for when the Department Name equals a value. Something along the lines of: CASE WHEN 'Department Name' = "Revenue" THEN ABS('Transaction Currency Amount') END Thanks for you response. Unfortunately I received the…
    in Beast Mode - Revenue from a negative to a positive Comment by user031733 May 2020
Default Avatar