Split a filtered field

[Coopedup]

I'm gathering the last Activity ID from my demand table. Result currently is Act-23. I want to them split this and take just the 23!  I'm really struggling to put a split into my existing formula. 

Last(Filter(DemandTbl, !IsBlank(ActID),ActID)).ActID

I suspect the biggest personal issue is I never know what order these commands go, do I put Split at the start or after the Filter!

[BCLS776 · Accepted solution]

Try this to get a value of "23" out of the Split():

Last(Split(Last(Filter(DemandTbl, !IsBlank(ActID),ActID)).ActID,"-")).Result

Hope that helps,

Bryan

[Nogueira1306]

Last(Split(Last(Filter(DemandTbl, !IsBlank(ActID),ActID)).ActID,"-"))