How to compare rows based on groups of data within a column

[J Zhou]

How do you add a calculated column that identifies within the same groups of [WheelsetNumber], there is differing [W05Wheelset] values within the rows

E.g. WheelsetNumber 100009 has KCLASS and GSHORT strings, I'd like it to return '1'. As opposed to 100920, where I want it to return '0' as all rows for 100920 have the same KCLASS strings in the [W05Wheelset] column. For wheelset numbers with one row, such as 100011, I want it to return '0' as well

I know I need to use a mixture of OVER functions but I'm out of my depth. Any help appreciated :)

[Fabian Duerr]

First, get the number of unique W05 per WheelsetNumber:

UniqueCount[W05Wheelset] OVER [WheelsetNumber]As you only want to return 0 or 1 (if more than one unique W05) you can expand this:

If(UniqueCount[W05Wheelset] OVER [WheelsetNumber] = 0, 0, 1)