Subtract Total

When iam Substracting total Values Getting Zero

Eg : TotalDB=SUM(DEBIT)
TotalDB=Sum(CR)

Bal=TotalDB-TotalDB ( This is getting Zero Value , if iam converting to Double or Decimal it is showing like String Value
(



Comments

  • StarkStark Syria
    edited 4:39PM
    you have the same variable name ? TotalDB !!!


    May be you must try this
    ToalAfterSubtract = Sum(debit) - Sum(Cr)
    

  • edited 4:39PM
    i have used same variable, it is showing like string value. ( 155.00-255.00) not - 100
  • StarkStark Syria
    edited 4:39PM
    Ah , I got it now !


    Include expression with this things [ ]

    Like
    [Sum(Debit) - Sum(Cr)]
    


    Hope this help
  • edited 4:39PM

    Thank you Stark,

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.