topic Re: WRS displays mixed results using the DOLLAR6.0 format in InfoMap in SAS Web Report Studio https://communities.sas.com/t5/SAS-Web-Report-Studio/WRS-displays-mixed-results-using-the-DOLLAR6-0-format-in-InfoMap/m-p/34552#M589 It sounds like the length isn't long enough. <BR /> <BR /> For instance - if the amount is $100,000,000 with dollar6.0 would show 1E8.<BR /> Likewise, if the amount is $100,000 it would show 100000.<BR /> If it was $10,000 it would show $10000<BR /> and if it was $1000 it would be $1,000.<BR /> <BR /> The , and the $ are included in the length of the variable.<BR /> If your largest variable is 17 numbers 'long', I would suggest attempting a dollar23.0.<BR /> <BR /> Hope this helps.<BR /> ~ Angela<BR /> <A href="http://sas-bi.blogspot.com" target="_blank">http://sas-bi.blogspot.com</A> Tue, 15 Jun 2010 13:45:36 GMT AngelaHall 2010-06-15T13:45:36Z WRS displays mixed results using the DOLLAR6.0 format in InfoMap https://communities.sas.com/t5/SAS-Web-Report-Studio/WRS-displays-mixed-results-using-the-DOLLAR6-0-format-in-InfoMap/m-p/34551#M588 My WRS report displays numeric data as mixed - some have $, commas, 1.05E16, etc. I've tried various formats in the InfoMap, with no luck. <BR /> <BR /> Any ideas?<BR /> <BR /> Thanks Fri, 11 Jun 2010 12:44:51 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/WRS-displays-mixed-results-using-the-DOLLAR6-0-format-in-InfoMap/m-p/34551#M588 deleted_user 2010-06-11T12:44:51Z Re: WRS displays mixed results using the DOLLAR6.0 format in InfoMap https://communities.sas.com/t5/SAS-Web-Report-Studio/WRS-displays-mixed-results-using-the-DOLLAR6-0-format-in-InfoMap/m-p/34552#M589 It sounds like the length isn't long enough. <BR /> <BR /> For instance - if the amount is $100,000,000 with dollar6.0 would show 1E8.<BR /> Likewise, if the amount is $100,000 it would show 100000.<BR /> If it was $10,000 it would show $10000<BR /> and if it was $1000 it would be $1,000.<BR /> <BR /> The , and the $ are included in the length of the variable.<BR /> If your largest variable is 17 numbers 'long', I would suggest attempting a dollar23.0.<BR /> <BR /> Hope this helps.<BR /> ~ Angela<BR /> <A href="http://sas-bi.blogspot.com" target="_blank">http://sas-bi.blogspot.com</A> Tue, 15 Jun 2010 13:45:36 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/WRS-displays-mixed-results-using-the-DOLLAR6-0-format-in-InfoMap/m-p/34552#M589 AngelaHall 2010-06-15T13:45:36Z