Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I have an issue with a set analysis formula that I cannot figure out what is wrong with it. I am trying to have the formula display the value of (AFPO.WEWRT/AFPO.PSMNG) where the ProductionStartMonth (formatted as a date MM-YYYY) is the maximum which would display the newest price per unit.
The formula I came up with is MAX({<ProductionStartMonth=MAX(ProductionStartMonth)>} (AFPO.WEWRT/AFPO.PSMNG)) but that isnt working. The error message starting after the }. What am I missing with this?
Seems like what you really need is a FirstSortedValue() function instead of set analysis....
I've never used that function. Can you assist me with its syntax? Tried
FirstSortedValue(AFPO.AUFNR, AFPO.STRMP, 1) as NewestOrder,
Where AFPO.AUFNR is the Production order number. but it errors out.
You need to do this in the script?
I dont need to I thought that was where the function was usually implemented per the examples I saw.
Can be implemented on the front end as well. firstsortedvalue
I don't think I can give you the exact expression without testing it out based on your dimension and expectation, but feel free to try it out.
Appears this may be working. Have to have a coworker verify in the system.
FirstSortedValue((AFPO.WEWRT/AFPO.PSMNG), -AFPO.STRMP, 1)