Alteryx is not giving an error when field is not present in source and use it for any summarized max, min, avg, sum, functions.
Alteryx will throw an error when field is not present in source, but used in Group by Action.
This cause unexpected results. please find attached workflow where green container gives me correct results versus red one is not.
In summary, Alteryx must throw an error when field is not in present in Fields section which produce unexpected results.
in below example Building field is not even present in fields but there is no error.
expected value of summary tool was
but because there is no error, Alteryx is giving below which is count than i wanted is sum of pre-calculated field.
@KeyMaker
Basically on my test, there is an exclamation mark mark on the icon of Summarize Tool and there is an error message also showing when I run the flow.
Just in case, can you your setting on "Disable Auto Configure" in the user setting menua?
Thanks. Did you able to open my workflow with example ?
I think your example has City as Group by.
Use City Field like count(City) instead of group by and remove City field from source fields. it won't give an error.
1. Add City Field
2. Count (City)
3. Remove City from source fields and run flow.