Forum Discussion
JeffH
6 years agoHelper I
Help
Hello, I have data given to me in the following format. Basically it is truckloads with mulistops on them. The data shows the load ID but has the total load cost on each stop row. I need to show...
- 6 years ago
Hi,
Does this work?
=SUMX(VALUES(Data[CHRNumber]),[Load Cost])
JeffH
6 years agoHelper I
Thank You, that did the trick. However I should have mentioned that I need to be able to total my load costs. Using the MIN function just shows the MIN load cost rather than the totals. Is there a way to total this?
Ashish_Mathur
6 years agoSuper User
Hi,
Does this work?
=SUMX(VALUES(Data[CHRNumber]),[Load Cost])