Formula issues multiplying multiple rows

mckenseycatterton

I created a summation to get a multiplier by priority rating and the number of times that multiplier showed for the priority rating, see below screenshot. The next steps I am having issues with:

1. Multiplying the timeliness multiplier by count for all rows

2. Summing the outcome of 'Multiplier x Count' by priority 

What I have:

First summation:

Select (for some reason I lose the multiplier for the anything that isn't a '1'):

Formula:

Final summation:

What I want it to provide:

IraWatt

Hey @mckenseycatterton, you will need to convert timeliness multiplier to a double not an integer. You will probably need to add a zero before the '.' to do this. This will stop the null values and you will be able to multiply with it.