I'm trying to parse a Parameter in a Formula to have it displayed and this doesn't seem to work:
Right({?@ByPaymentType}, Length({?@ByPaymentType})-InStr({?@ByPaymentType}, "By")+1)
Tried this too:
Right({?@ByPaymentType}, Length({?@ByPaymentType})-InStr({?@ByPaymentType}, "By")+3)
It is displaying the entire value of the Parameter, @ByPaymentType.
The values being passed are one of the following:
"By Cash" "By Check" "By Credit Card" "By Money Order" "By Direct Deposit" "By Wire Transfer" "By Other"
and I want to display:
"Cash" "Check" "Credit Card" "Money Order" "Direct Deposit" "Wire Transfer" "Other"