Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have text box which shows max value of price/cost according to product dimension. I want to show product name in text box.
Hi,
I already answered in your previous post, but here we go
=Only({1}
If(
Aggr(
Rank(
Sum({1< Employee = {'Jae Pak', 'Tsvi Reiter'} >} UnitPrice) / Sum({1< Employee = {'Jae Pak', 'Tsvi Reiter'} >} TotalProductCost), 4, 1)
, Product) = 1
, Product)
)
Kind of cumbersome because of the selection, that you want to ignore, hence all those {1}.
Hope that helps.
BI Consultant
Hi,
I already answered in your previous post, but here we go
=Only({1}
If(
Aggr(
Rank(
Sum({1< Employee = {'Jae Pak', 'Tsvi Reiter'} >} UnitPrice) / Sum({1< Employee = {'Jae Pak', 'Tsvi Reiter'} >} TotalProductCost), 4, 1)
, Product) = 1
, Product)
)
Kind of cumbersome because of the selection, that you want to ignore, hence all those {1}.
Hope that helps.
BI Consultant