I am querying a Statistics Collector table from a Calculated Table. I prefer to write SQL directly, so I need to specify the data format in the Display Format pane, but there is no string option?
You just use raw option, and if the field expression is a string, the result's field will be a string. The problem looks like it's your use of MAX with a string value - which equates to zero.
Thanks Jason. The problem is that I am used to DB2 SQL, so I didn't consider that FlexSQL do not handle aggregate functions for strings.
Understood. Generally FlexSim's query language is closest to MySQL's implementation which I think in this case has the same numeric requirement for MAX().
14 People are following this question.
