I need to get the total 2 fields together, see screenshots below
*This post is locked for comments
I am not sure if i understand your question correctly, in your total textbox why can't you use SUM(Fields!TempSalesLineQuantity.Value) + SUM(CustUOMQty) as expression
Unless i am missing something it is little confusing to me.
Hi,
If you look at the Sum function, if has got three different signatures; as below:-
=Sum(Fields!YearlyIncome.Value)
=Sum(Fields!YearlyIncome.Value,"GroupByInitial")
=Sum(Fields!YearlyIncome.Value,"GroupByInitial",Recursive)
You may use the second signature which will automatically change as and when the group changes, basically you can have groupwise total.
Best Regards,
MMV
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156