Hi from one my expression rule I am getting output as ; ; ; [value]; ; can yo

riyazs over 9 years ago

Hi from one my expression rule I am getting output as ; ; ; [value]; ; can you suggest me a function here which removes null values and gives me just [value].

thanks

Discussion posts and replies are publicly visible

Parents

0 Chris over 9 years ago

Try filternulls(). Additionally, we use a custom rule filterblanks() defined as:

=remove(ri!array,wherecontains("",ri!array))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Chris over 9 years ago

Try filternulls(). Additionally, we use a custom rule filterblanks() defined as:

=remove(ri!array,wherecontains("",ri!array))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data