none
How to Write Expression to Subtract

    Question

  • Amount             Settled Amount        Balance Total

    3,300                    1,100                     2,200

                                 2,200                    1,100

    Expression for Amount:

    =Fields!Totalamount_fc.Value

    Expression for Settled Amount:

    =Fields!Spentamount_fcd.Value

    Expression for Balance Total:

    =Fields!Totalamount_fc.Value - Fields!Spentamount_fcd.Value

    How to Write an Expression to Subtract the Amount 3,300 to the (1,100+2,200) to make it 0?

    Wednesday, April 24, 2019 7:21 AM

Answers

  • Hi ,

    Sorry can't fully understand you statement? What do you mean to "make" it 0?

    Could you please to clarify the logic of the subtraction so we could provide suitable support?


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Wednesday, April 24, 2019 9:36 AM
  • Hi 

    Have you resolved your issue? 

    If no, could we offer more support? :)

    regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by alyaswaway Thursday, May 9, 2019 3:28 AM
    Friday, April 26, 2019 8:58 AM

All replies

  • Hi ,

    Sorry can't fully understand you statement? What do you mean to "make" it 0?

    Could you please to clarify the logic of the subtraction so we could provide suitable support?


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Wednesday, April 24, 2019 9:36 AM
  • Hi 

    Have you resolved your issue? 

    If no, could we offer more support? :)

    regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by alyaswaway Thursday, May 9, 2019 3:28 AM
    Friday, April 26, 2019 8:58 AM