locked
RDLC Expression for report need to be modified RRS feed

  • Question

  • User1182587605 posted

    I am working on a Legacy application, In old VB application report, I have an expression

    bCYrShrinkPerc = round((bCYrShrink / CYrShipVal) * 100)

    I am working on RDLC and am creating a report for the same. Please check my expression. I get values of percentage like 10233.23% which is not at all correct. Please help me with this..

    =iif(Fields!bCYrShrink.Value/Fields!CYrShipVal.Value>0,((Fields!bCYrShrink.Value/Fields!CYrShipVal.Value)*100),0)

    I think I am doing it correctly but there is an issue with this expression...

    Friday, June 23, 2017 9:20 AM

Answers

  • User1068175894 posted

    there are a couple of issues here:

    if the purpose of the iif is to prevent division by zero yo should do:

    =iif(Fields!CYrShipVal.Value>0,...

    you also got rid of the round function

    the other issue probably is the datatype on the report field is percentage, then it will multiply by 100 so remove "*100" from your formula

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, June 24, 2017 3:55 PM