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 · Accepted solution]

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. 

[mckenseycatterton]

Thank you!!! that resolved ALL my issues. 

[IraWatt]

No worries @mckenseycatterton ! :) glad it worked for you