SUM by text Property: Calculation function
I have a List Dept L3 where I want to SUM my $ Values in a module by its Code i,e not a Code of my item but a text formatted property which says Dept Code. I want to apply Sum by 'Property code'(830) in a list as shown in attached snapshot.
Highlighted items are child of different parents. 830 is the Property code for which, I want to sum the dollar value
for '830_SupChn' and '830_TSP'. As this is a text formatted property, so SUM function doesn't work on it.