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