This content has been marked as final.
Show 2 replies

1. Re: Problem with "Sum of Max" and "Sum of Min"
Jonathan Drummey Jul 10, 2012 11:21 AM (in response to Serge GABRIEL)Hi,
Attached is one method. A table calc called "Min Price jtd" using IF FIRST()==0 THEN WINDOW_MIN(SUM([Price])) calculates the minimum price, with Compute Using set to Supplier but only returns a result for one row in the partition. Then a "Total Min Price jtd" calc using WINDOW_SUM([Min Price jtd]) totals up all the minimum prices. Two more calcs do the same for the Max price.
Cheers,
Jonathan

sum of max and min.twbx.zip 33.8 KB


2. Re: Problem with "Sum of Max" and "Sum of Min"
Serge GABRIEL Jul 16, 2012 1:05 AM (in response to Jonathan Drummey)Thanks Jonathan, it's a perfect solution: