Concat summary numbers

louiswatson
louiswatson Member
in Magic ETL

Hi, I'm trying to use the CONCAT function to combine two calculations into one summary number.

I want to put Sites = Count of Panels, Panels = Sum of Panels

I have done the CONCAT function but it is multiplying the numbers together it seems, I must have missed something and wasn't sure what: CONCAT(COUNT(Panels), SUM(Panels))

If someone knows it would be much appreciated

Best Answers

  • trafalger
    trafalger Coach
    Answer ✓

    I'd try putting a space between the two just incase, like ' '.

    But your logic is sound, that should have worked.

  • marcel_luthi
    marcel_luthi Coach
    Answer ✓

    Agree with what @trafalger suggested, without any other character CONCAT will likely put the two numbers together, so 10 and 20 would be displayed as 1020. Adding the "template" of the string you want to display to the formula should work, something along the lines of:

    CONCAT('Sites = ',COUNT(Panels),', Panels  = ',SUM(Panels))

Answers

  • trafalger
    trafalger Coach
    Answer ✓

    I'd try putting a space between the two just incase, like ' '.

    But your logic is sound, that should have worked.

  • marcel_luthi
    marcel_luthi Coach
    Answer ✓

    Agree with what @trafalger suggested, without any other character CONCAT will likely put the two numbers together, so 10 and 20 would be displayed as 1020. Adding the "template" of the string you want to display to the formula should work, something along the lines of:

    CONCAT('Sites = ',COUNT(Panels),', Panels  = ',SUM(Panels))

  • louiswatson
    louiswatson Member

    Thankyou both, this worked a treat!

Categories