ssrs calculation not working

  • I have a SSRS report that i need to calculate the Variance percent totals

    which the math logic goes Occupied Variance % - Vacant Potiental percent - Damaged Potiential percent

    Occupied Variance = 5%

    Cacant Potiental = -5%

    Damaged Potiential = -3%

    so it 5% -(-5%) -(-3%)

    How do i write this in a SSRS expressionvariance

  • Wouldn't you add the absolute values?

    5% + abs(-5%)  + abs(-3%)

     

  • Even if I do that I still get the percentage value too high it 91% when the percent suppose to be 4.5%

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply