Multivalue if....then (OpenInsight 32-bit Specific)
At 05 JUL 2005 11:03:16PM Marty Rosenbloom wrote:
Hi,
I am suffering from brainus crampus. I know what I am looking for is very simple.
On my edit table I have an MV column called "ROW." The values of row are numbers from 1 to 30. I am creating an MV calculated field called "TIME" that I want to translate the value in "ROW" to a specific value. For example: If the value of "ROW" equals 5, then the corresponding row in "TIME" would be 9:15.
My formula is:
Row={ROW}
If Row=5" Then
@Ans=9:15"End Else
@Ans=Nope"End
All I get is "Nope" in the first row and nothing below. All columns are MV and I am using OI 7.1.1.
TIA,
Marty
At 05 JUL 2005 11:12PM Barry Stevens wrote:
Row={ROW}
Cnt=count(Row,@vm)
for X=1 to Cnt
If Row=5" Then@Ans=9:15"End Else@Ans=Nope"Endnext X
At 05 JUL 2005 11:13PM Barry Stevens wrote:
.
Cnt=count(Row,@vm)+ (Row "")
.
.
.
At 05 JUL 2005 11:33PM Marty Rosenbloom wrote:
Barry,
Thanks for the help. I knew that the solution would be fairly simple. I was actually working with counting entries and looping for answers. I hadn't reached your soulution, however, so I still wasn't "getting it."
Again, I appreciate the help!
Marty
At 06 JUL 2005 05:14AM Richard Guise wrote:
Should one also explain that the {..} calculation of dict items is affected by the value of system variable @MV.
@MV is normally zero or null and {…} will return all multivalues.
In some operations, e.g. screen handling and exploding sort, @MV is set to the required multivalue number and {…} returns just that multivalue.
Especially when reporting with exploding sort, there are therefore some situations (e.g. working the mvs' individual %ages of their total) when it may be necessary to store the value of @mv before a {…}, set it to 0 for part of the computation and restore it afterwards (e.g. to work the total of the mvs for the %age).