Ciclic Group From Expression

[#1]

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)))

Thanks in advance.

[Sokkorn]

Hi Pedro,

I thinks GetCurrentField(GroupName) will do this.

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

Please ignore formular checker.

Do let me know if this one help you.

Regards,

Sokkorn

[#3]

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),
IF(GetCurrentField(MadEnv)='Kilos',Sum(Kilos),Sum(Amount)/Sum(Kilos)))

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

[#4]

What did you mean with "Please ignore formular checker"

[Sokkorn]

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

[Sokkorn · Accepted solution]

Hi Pedro,

Let do this

IF(WildMatch(GetCurrentField(MadEnv),'*Amount*'),Sum(Amount),
IF(WildMatch(GetCurrentField(MadEnv),'*Kilos*'),Sum(Kilos),Sum(Amount)/Sum(Kilos)))

Let me know with this expression.

Regards,

Sokkorn

[#7]

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