Skip to Content

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

Extract all the values from a Bex measure in formula


I am pretty new to crystal and I am not being able to extract all the values from a bex measure inside my new formula. My measure could have one of the following 3 formats:

1) will contain only one entry that of a "#"

2) will contain 2  or more (typically not more than 3-4 entries though) entries, first of which will be a "#" and the rest will be dates in the format mm/yyyy

3) will contain multiple entries all of which will be dates in the above format.

in the formula when I am trying to do {ZMICMAM05_ZWK_AM_ZMICMAM05_Q0013_2.[ZCALMTO]}[1] I do get the first entry but  {ZMICMAM05_ZWK_AM_ZMICMAM05_Q0013_2.[ZCALMTO]}[2] this doesnot give me the second entry instead only a blank.

Thanks for help!!!

Former Member

Helpful Answer

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