Forum Discussion

AndrewPF's avatar
AndrewPF
Helper V
2 years ago
Solved

nullable integers?

I have a group by function with text, numbers, dates and logicals, but I need some of the numbers to be integers. 

It's easy enough to add a "change type" step after the grouping, but I can't help feeling there is a shorter way of doing it. 

At the moment, I have this clause: 

"statusId", each List.Max([statusId]), type nullable number"

but I really want is something like: 

"statusId", each List.Max([statusId]), type nullable integer"

Is this possible?  Or do I have to stick the two-step process? 

1 Reply

  • Hi

     

    ... type nullable Int64.Type...

    Stéphane