Let me preface this by saying that I use custom summary numbers on a lot of cards and I format the html to include colors and symbols so I feel a little embarassed making this post. Recently I have custom summary numbers that will not work on one dataset but work on another. For the life of me I cannot figure out why, so I was hoping somebody could point out the probably obvious answer that is escaping me.
Here is a very simple example that works on one dataset but not another. The dataset that displays 'No Summary Number' with this beast mode does not have any null values for quantity so I cannot figure out why this would not work. What else should I be looking for? Thanks in advance for your help.
concat(case
when length(sum(`quantity`))=4 then concat(substring(sum(`quantity`),1,1),',',substring(sum(`quantity`),2,3))
else sum(`quantity`)
end)