[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Bug displaying calculated MV fileds (Reporter Specific) ====
=== At 11 MAY 1998 12:32:51PM Andy Gilman wrote: ===
 
{{tag>"Reporter Specific"}}
 
<QUOTE>
Multi-value options do not appear to work correctly with calculated fields in Revelation reporter.



I create a single record with one multi-value field (test_col) containing 

two values: VALUE_1 and VALUE_2



I display this field on a report and it correctly shows:

(MV options are Treat as Multiple Records, If One Value Matches then Return All Values)



test_col



VALUE_1

VALUE_2



I then create a calculated field with formula @ANS={test_col}



I make this a multi-valued field and display it alongside the original 

(with the same MV options).  I get the following INCORRECT result:



test_col	   	calc_field



VALUE_1     	VALUE_1

VALUE_2



If I use "Treat as a Single Field" with comma separator, it is correctly dislayed as:



test_coL     	calc_field



VALUE_1   	VALUE_1, VALUE_2

vALUE_2



Thanks in advance for any help.


</QUOTE>

[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=8E0F57A6C6A6B24185256601005AE5FF|View this thread on the  forum...]]