I assume that you have an issue with interpreting your thousand separator, assuming that your minutes field is formatted like '1,000'. Or I have misunderstood your posting. How do you read in the fields and how do you transform your fields then?
Could you post your load statement used here in the forum or a small sample app?
Here is an example depicting the same situation:
From NHL .com statistics
When selecting a player from the player list such as Anthony Stewart, ES TOI (even stregth Time on Ice 596 minutes everything works perfectly. I see the productivity (minutes of ice time per goal scored and effectiveness minutes of ice time per goal allowed.
the expresions I use are = [ES TOI]*24/ESGF and [ES TOI] *24 / ESGA
When I select a player like Brandon Sutter who has 1196 minutes of ice time ÈS TOI] the boxes with the calculated fileds indicate that there is no data to display.
I appreciate of your assistance.
Message was edited by: stevenmorein ( fixed typos)
NHL-example-CAROLINA-2011.qvw 180.0 K
I think my assumption was correct, that there is a problem with number parsing.
If you look at the table viewer or e.g. in a table box, you'll notice that some records for TOI or ES TOI are formatted differently (left aligned), indicating that they were read in as text, not as number. These records have a thousand separator ',' in their minutes value, like '1,234:56'
If you want to do some calculations, you need to read all records in as numbers. Unfortunately, QV won't recognize a time format with a thousand separator.
But you can just remove the comma using purgechar() function:
purgechar([ES TOI],',') as [ES TOI],
purgechar(TOI,',') as TOI,
(html, codepage is 1252, embedded labels, table is [2011-2012 - Regular Season - Carolina Hurricanes - Skater - Time On Ice - Total Time On Ice], filters(
Remove(Row, Pos(Top, 2)),
Remove(Col, Pos(Top, 1))
Hope this helps,
NHL-example-CAROLINA-2011_SW.qvw 178.5 K