Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a detail list where I calculate the column "Division owner" with
=FirstSortedValue({$<Portal_Division_Name=, Division=,DivisionInternalName=,DivisionName=,Portal_Division=>}Division,-Aggr(sum({$<Portal_Division_Name=, Division=,DivisionInternalName=,DivisionName=,Portal_Division=>}LineAmount_EUR),Division,[Supplier number]))
And now I want to use the value in this column "Division owner" to get the value for Purcahser in my set analysis
I have tried both
=MinString({$<Division={'[Division owner]'}>}Purchaser)
and
=MinString({$<Division={$(=[Division owner])}>}Purchaser)
May be this:
=MinString({$<Division={"=Division = FirstSortedValue({$<Portal_Division_Name=, Division=, DivisionInternalName=, DivisionName=, Portal_Division=>}Division,-Aggr(Sum({$<Portal_Division_Name=, Division=, DivisionInternalName=, DivisionName=, Portal_Division=>}LineAmount_EUR), Division, [Supplier number]))"}>} Purchaser)
May be this:
=MinString({$<Division={"=Division = FirstSortedValue({$<Portal_Division_Name=, Division=, DivisionInternalName=, DivisionName=, Portal_Division=>}Division,-Aggr(Sum({$<Portal_Division_Name=, Division=, DivisionInternalName=, DivisionName=, Portal_Division=>}LineAmount_EUR), Division, [Supplier number]))"}>} Purchaser)
I thought I tried it, but must have missed something. Thanks!
No problem at all