SSRS 2012 - Visual Studio 2012 - SQL 2012
I have a field called "Trend" and a field called "Multiplier" that I was to multiple together. Then I need to take the sum of those two fields and roundup to a multiple of a field called "Inv_Max"
For example: Trend is 1572 and multiplier is 3. (1572 * 3 = 4716) The Inv_Max field is 2400 so I want to roundup the 4716 to 4800, which is a multiple of Inv_max.
I want to be able to add a calculated field and can't figure out the formula.