Thank you for responding. Through trial and errors I figured that even after applying Max’s syntax i was getting error in the view because of the string manipulation calculated field.
I also found a post where someone had similar issue. Basically, I cannot use a calculated field as a partition by field in a separate calculation… I need to move that calculation to the data set layer, which is kinda annoying and time-consuming.