I have an Editable list view with fields as below:
- ResourceType: {drop-down list} Values: Internal, External
- Hours: {Number field} - This stores hours
I would like to get a summation of Internal hours seperate then external hours. Currently I am just getting summation of all the hours but I need to break it down by Internal hours and External hours.
Basically, how do I use the following expression:
If ResourceType = Internal Add hours and store the value in a seperate field called - Total Internal Hours
I get List Sum (Hours) but how do I add If statement