I am stuck with deriving percentage using Max function in my report development.
I need to calculate the Max(%) comparing PO and Item. When i am using the function
=Max(%) ForEach([Item]) In ([PO]) its not giving right value as expected. Can anyone please help me with correct formula.
The data table is as below and Yellow column is expected one.PO Item % Max(%)