Post reply

Calculating a % based on table results

  • January 25, 2018 at 6:08 am

    #342990

    Can anyone tell me why the below expression is reporting an incorrect % figure on my report

    =ReportItems!YTLP.value + ReportItems!TSA.value / ReportItems!YT.value

    Thought this would work but the result is massively out

    Thanks in advance
    Chris

  • January 25, 2018 at 7:30 am

    #1977334

    are you trying to do =(ReportItems!YTLP.value + ReportItems!TSA.value) / ReportItems!YT.value ?

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • January 25, 2018 at 7:34 am

    #1977335

    Thanks Jonathan that was exactly what I was trying to do

    🙂

  • January 25, 2018 at 7:57 am

    #1977343

    cmw 66135 - Thursday, January 25, 2018 7:34 AM

    Thanks Jonathan that was exactly what I was trying to do

    🙂

    For more information on this error and to prevent it in the future, I suggest that you read about PEMDAS or Operators Precedence.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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