Creating two columns cash book
Hello Experts. Am having a bit of some challenge, trying to implement a two-column cash book logic as an expression on sql server report builder The idea is to subtract [Debit amount] – [Credit Amount] = [Balance] However, am unable to write an expression that subtracts OR add automatically to the [balance] as a result of input on the [Debit amount] OR [Credit Amount] columns .
Paginated report Expression column sum() Grand Total
Hello Gurus, I am working on a Paginated report where I have created a expression column, I need to show grand total of this expression column. Highlighted in Yellow. How to use following formula? Expression Formula : =Sum(IIf( (A - Sum(B)) >Sum(C), Sum(C) , (A-Sum(B)) ) )
