Post reply

ssrs calculation not working

  • August 19, 2022 at 4:55 pm

    #4078458

    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

  • August 19, 2022 at 10:05 pm

    #4078572

    Wouldn't you add the absolute values?

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

     

  • August 19, 2022 at 10:23 pm

    #4078580

    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 2 (of 2 total)

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