I guess the better question - can you get the over...
# suiteanalyticsk
KevinJ of Kansas
03/10/2023, 2:20 PMI guess the better question - can you get the overall results of a minimum given a different criteria than the grouped data set.
n
Netsuite Tragic
03/15/2023, 2:09 PM@KevinJ of Kansas we all know it's not possible...but I think I cracked it. Is this what you want?
Netsuite Tragic
03/15/2023, 2:22 PMI think your need is met with MIN ({amount}) OVER(ORDER BY {internalid} ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
Netsuite Tragic
03/15/2023, 2:23 PMIn my search I had transactions with values of 25014
2130
384
1149
30758
Netsuite Tragic
03/15/2023, 2:25 PMFOr each of the 5 lines the formula returns 384 for the results column. When I removed the 384 line it returned 1149. I'm thinking you can do your comparisons.
Netsuite Tragic
03/15/2023, 2:26 PMI also played with an overall Average. The version I did was compare the transaction amount to the average of all the transactions in my search. I had to calculate my own overall average function as you will see.
Maybe you can hack this for your needs
CASE WHEN {amount} > SUM ({amount}) OVER(ORDER BY {internalid} ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)/COUNT ({amount}) OVER(ORDER BY {internalid} ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) THEN 'Greater' ELSE 'Other' ENDNetsuite Tragic
03/15/2023, 2:27 PMFor changing the criteria, I think wrap {amount} in either DECODE or CASE to apply additional criteria.