Hi, I'm new to splunk and am hoping to get some advice and help. I'm trying to do a addcoltotals but with different weights for each row. After a table function my data looks like: Size Index Large 0.45 Medium 0.7 Small 0.9 I want to do a weighted summation with specific values (I've bolded them below - these values are constant): totalIndex = 0.2 X (Index[Size="Large"])+ 0.7 X (Index[Size="Medium"]) + 0.1 X (Index[Size="Small"]) After I should have one stat value = 0.2 X 0.45 + 0.7 X 0.7 + 0.1 X 0.9 = 0.67 Thank you! ... View more