Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem using alternate state in comparison of elements of fields.
I have table:
Groups |
Main1 |
Main2 |
and following tables:
Main1 |
A_1 |
B_1 |
C_1 |
Sub1A |
1 |
2 |
3 |
Sub1B |
4 |
5 |
6 |
Main2 |
A_2 |
B_2 |
C_2 |
Sub2A |
2 |
3 |
4 |
Sub2B |
5 |
6 |
7 |
the formula for calculation is:
let vFormula='if(GetSelectedCount(Main1)=1,A_1*2+B_1*3+C_1*4,0)+if(GetSelectedCount(Main2)=1,A_2*2+B_2*3+C_2*4,0)';
I created two Alternate states: As1 and As2 and applied them to two Filter panes:
First filter pane: Groups;
Second filter pane: ="$(=GetFieldSelections([Groups]))";
When I use a bar chart to show result of the formula and set alternate state to As1 for the chart, the formula works.
When I want to compare two groups, I need to set bar chart to default state, and write formula like this:
But it does not work.
If I create formula like this:
It works but the bar chart does not show correct value.
If I set formula like this:
It works. But if I set formula like this:
It does not work.
What I need is that when I select one sub field of Groups I get the correct value in chart.
How should I define set analysis and expression so I can get what I need?
Thanks.