When you say straight table do you mean the expression for Remaining? Please provide more details to solve it quickly. I mean I have no understanding of your data model. So please provide more explanation referring to your sample document.
I need the remainingoutgoing value in straight table but value will be max date value. when u select the customer no. , the customer's last date values i need it on the report. when you click the customer no. C000003 you can see some amount in report when u unselect or clear then it wont show that amount, but i want to show that amount without selecting the customer also.
I am having a problem solving this one. Because the Date in your data is not a single value and we need to compare this with our variable vMaxDate. So I am still trying to think of ways to overcome this issue. I'll get back to you as soon as possible. Meanwhile if someone can contribute that would be brilliant.
If you use this expression in Remaining Column it shows up the values but it not right for all the customers. I am afraid same is the case with your example. I mean lets say for example customer : C000002 total should be 34.13 instead of -52.03. And even the [Remaining] value should be 0 instead of -86.61.
I am attaching the file which I am working on. I might be wrong but thats what my understanding is...
Antony - If you see my attachment. I am getting the values for [Remaining] column without selecting the customer. For example for C000003 the value -0.37. However, for other customers the expression is calculating for all the dates instead of calculating for the MaxDate. That's what I need to tackle now.
Also in my example attached the expression should be divided by 100000 instead of 10000. I had amended this and use this expression meanwhile.
