Last post Jun 24, 2017 03:55 PM by JBetancourt
Jun 23, 2017 09:20 AM|acmedeepak|LINK
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..
I think I am doing it correctly but there is an issue with this expression...
Jun 24, 2017 03:55 PM|JBetancourt|LINK
there are a couple of issues here:
if the purpose of the iif is to prevent division by zero yo should do:
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