I am trying to take a number and fit it in a group and multiply all preceding groups and the existing group by a multiplier and all other numbers in the table be 0.
For instance if my number is 313 then I will have 150 in the summary field for that row and 350 in the next and then I will take the minimum of 201 which is 112 and multiply it by 1.35 and the next two results will be zero.
6-19-2013 7-31-55 AM.jpg
this is the formula I was using where column H is the first column you see.
Any help would be appreciated as I don't do this often and I had no success with the Vlookup but I think it might be able to work with that formula as well.
Please Login or Register to view this content.