Sharepoint designer has the trait of getting goofed up with calculated columns that display with a comma. I typically deal with this by doing a format-number(number(translate(@MyCalculatedColumn,',',')), ###$%%^formatstuff). this replaces the
comma's with nuthing so it will format as a number.
I'm trying to do a sum now...is this possible?
<xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row[contains(@FileRef,$TheIDweWant)]"/>
<xsl:variable name="zNumMales" select="sum($Rows/@MaleLives)"/>
<xsl:variable name="zTotalMaleVolume" select="sum($Rows/[number(translate(@MaleVolume,',','))])"/>
The zNumMales works fine...it's just a number column populated by a workflow.
The zTotalMaleVolume is calculated, has commas so it displays as blank, we need to get rid of the comma's. the above syntax is upchucked...anyone happen to know what it is?
View Complete Post