hello,

I have a formula that I can not write well. Please help me to solve the task.


There is a running total evaluate:
{report.mak} in [array]

The [array] I would like to build in a formula (depending on a parameter):
Select {?Pmak}
  Case "fruit": "apple", "pear", "peach"
  Case "drink": "cola", "water", "wine"

How do you write the formula to make it work the IN clause?

The goal of this (if {?Pmak} = "fruit")
{report.mak} in ["apple", "pear", "peach"]


I tried these versions, but none of them worked:
  Case "fruit": "apple" + "," + "pear" + "," + "peach" (I got an incorrect results)
  Case "fruit":  array ["apple", "pear", "peach"] (I got an error message)

Thanks
gmac

ps: Sorry for my English

Not really. Your formula result is a string. If I use this formula in a running total, I not come really result. Because the IN clause work with array, not a string.

My goal is the correct running total:
{report.mak} in {@formula}

But I can't write the correct formula.

Thanks!

Kostya1122, when I write your code in the running total evaluate, the result is good. But you don't use formula, you write every condition in the running total. It's not good for me, because I have more running total and I want to display the array in the report.

I want a formula in which the array is created, and I want use this formula in the running total evaluate.

Thanks



Edited by gmac - 23 Jul 2014 at 8:36pm