Hi all,
Is it possible to add a column that displays the overall sum value?
On the BAQ i have, i am able to add the sum line by line using this calculated field “sumhidden”:
sum(hide) over (partition by PartDtl.PartNum order by PartDtl.DueDate rows between unbounded preceding and current row)
I dont want this, i want each line to display the final value from the summary sum e.g. Sum for “counthidden”.
Any help would be much appreciated.
Many thanks
hymal7
If you leave out the order by clause it will just to a total for everything in the partition. Adding the order by makes it a running sum (which is what you don’t want if I am reading correctly).
sum(hide) over (partition by PartDlt.PartNum)
Thanks mate that fixed it!
I was blindly copying formulae without knowing how it works. this has been educational
I’ve been doing a lot of reading on this lately. This link explains the over clause pretty well.