Skip to main content
Question

Why is StatisticsCalculator returning null for min and max?

  • May 7, 2024
  • 3 replies
  • 137 views
b-rad
Contributor
Forum|alt.badge.img+1

Hi, I’m having an issue with the StasticsCalculator returning some nulls for min and max. And also some unexpected rounded max values.

 Input data

 

I’m calculating statistics on avg_dur field and grouping by SEG_ID. Unexpected results highlighted.

 

The avg_dur field is data type real32. For some reason changing the data type to real64 results in the stats being calculated as expected.


The ave_dur field was originally imported from an esri shapefile with data type .

 

3 replies

virtualcitymatt
Celebrity
Forum|alt.badge.img+47

Wow, ultra weird. Sounds like a bug. Is there anything in the log file, e.g., warnings? What version of FME are you running?

 

DanAtSafe
Safer
Forum|alt.badge.img+21
  • DanAtSafeSafer
  • Safer
  • May 7, 2024

Hi @b-rad Unfortunately this is a known issue, filed as FMEENGINE-82162.  I did find a crazy work-around, which was to add a Creator before the StatisticsCalculator and disable the connection between them.  I don’t guarantee this, but do let me know if it works for you. :^)

b-rad
Contributor
Forum|alt.badge.img+1
  • b-radContributor
  • Author
  • Contributor
  • May 8, 2024

Thanks @DanAtSafe. The Creator work around doesn’t seem to help me. But as mentioned I can change to real64 and as a workaround.

 

@virtualcitymatt I’m on 2023.2.1.0 but can also replicated on 2024.0.

DanAtSafe

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.