Dear All,
I have the following use case: for each document I need to compare if the value is 5 times more than average for given vendor and highlight such positions. This I have already done using domain table (formula also includes certain exceptions given by the business). The only problem is that is always counts values globally and does not limit to the document range from date range selected. Is there any way to make it work, so that the average is calculated only from the range of selected cases?
image879296 8.07 KB
image2105372 46.4 KB
)