No, nobody has come up with an answer yet that works. The problem is that I want to only show labels under certain conditions. For example, I want the map to display all values > $1Mil in large type with the formatting $##Mil. Then I want anything over $100k but under <$1Mil in a smaller font with the formatting $###k.
In Pro I would simply write queries, add the results to the mapper and create the labels. Spectrum does not support dynamic queries / selections.
So then I tried to use a clever workaround someone developed where the label only gets displayed if the condition is true (see example below), but Spectrum does not support some of these basic string manipulation functions.
So I am still stuck. The real problem is that Spectrum was not developed by MapInfo, but by PB -- so the uploader from Pro is going to have lots of incompatibilities.
We must have a better tool for creating maps in Spectrum, or have the tool fix all the incompatibilities.
-- Steve
Left$(Str$(Format$(Int(SumOfIncur/100000)*100, "$#k")), Int(SumOfIncur>=100000 and SumOfIncur<1000000) * Len(Str$(Format$(Int(SumOfIncur/100000)*100, "$#k"))))