6 Replies Latest reply: Jun 12, 2012 7:33 AM by Sokkorn Cheav

# Ciclic Group From Expression

Hi I have a Ciclic Group with 3 values as a Dimension in a Graph, the question is: How can I make to get the current value from the expression. I mean

```IF( CICLICGROUP='ValueA', SUM(AmountA), IF(CICLICGROUP='ValueB', SUM(AmountB), SUM(AmountC)))
```

• ###### Re: Ciclic Group From Expression

Hi Pedro,

I thinks GetCurrentField(GroupName) will do this.

```IF(GetCurrentField(GroupName)='ValueA', SUM(AmountA), IF(GetCurrentField(GroupName)='ValueB', SUM(AmountB), SUM(AmountC)))
```

Regards,

Sokkorn

• ###### Re: Ciclic Group From Expression

Hi Sokkorn, thanks for your time, I can`t make it work. I don't know why. My Cyclical Group "MadEnv" has 3 posibles values. They are not "real" fields but text Expressions edited while the group was created. Like a list. The values are "Amount", "Kilos" and "UnitPrice".

So the expression should be

```IF(GetCurrentField(MadEnv)='Amount',Sum(Amount),
```

But It doesn't work. I'm doing something wrong for sure...

• ###### Re: Ciclic Group From Expression

What did you mean with "Please ignore formular checker"

• ###### Re: Ciclic Group From Expression

Hi Pedro,

When you apply `GetCurrentField(MadEnv) `then you will see the red line highlight this epression (normaly it mean wrong expression).

By the way, can you share your app? We look into it together to find solution.

Regards,

Sokkorn

• ###### Re: Ciclic Group From Expression

Hi Pedro,

Let do this

```IF(WildMatch(GetCurrentField(MadEnv),'*Amount*'),Sum(Amount),
```

Let me know with this expression.

Regards,

Sokkorn

• ###### Re: Ciclic Group From Expression

Yeah, the last one worked!! Thank you very much!!