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.
