SUM(field * field)

jhanvincent14jhanvincent14 Posts: 125Member
edited 2018-03-08 in NAV Three Tier
Hello good day, I'm having a problem with SSRS expressions. see attched photos for reference. I don't know why 1.png gives a the right value and the other one is #Error


  • basic0220basic0220 Posts: 15Member
    edited 2018-03-09
    I suggest you put the result of these two values in a variable through your code.

    make that variable a column under your DataItem and then try putting a SUM Function in the result variable in the expressions.

    tell me if this works. :smile:

  • RockWithNAVRockWithNAV Posts: 539Member
    First one seems to be a direct field and second one the variables. May be code flaw somewhere, try once taking this expression in a third variable and then put and check.
  • BlackTigerBlackTiger Posts: 1,065Member
    edited 2018-03-09
    Probably one of the field values has "null" instead of zero (for some reason). Use IIF and IsNothing to replace nulls by zero.
    "You can’t just ask customers what they want and then try to give that to them.
    By the time you get it built, they’ll want something new.” Steve Jobs
Sign In or Register to comment.