Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

sort multiple parameters by one field & the rest other field not working!

I want to sort based on a parameter "Status"; so if the status is Funded, Funded-as Asked, or Funded - New Designation, then I want sort by date funded field. Otherwise, I want to sort Date asked field.

Here is formula and I receive this error message: This array must be subscripted. For example, Array<i>.

if ({?Status}) in ["Funded","Funded - As Asked","Funded - New Designation" ] then

{CnPrProp_1.CnPrProp_1_Date_Funded}

else

{CnPrProp_1.CnPrProp_1_Date_Asked}

Not what you were looking for? View more on this topic or Ask a question