Acumulative option

[pgalvezt]

Hello!!

First - I have a formula where I bring Normal values - (its Works Fine)

If(VN= '$',
Num(Sum({<Vs={'O'},Year= {"$(=max(Year)-1)"}, Month>}
Value/Div)*Var,'$#.##0;$-#.##0'),
Num(Sum({<Vs={'O'},Year= {"$(=max(Year)-1)"}, Month>}
Value/Div)*Var,'#.##0'&' XT'))

Second -  I have the same formula but acumulative - (Its Works Fine too)

If(VN= '$',
rangesum(above( Num(sum({<Vs={'O'},Year= {'$(=max(Year)-1)'},Month>}
Value/Div)*Var,'$#.##0;$-#.##0'),0,rowno())),
rangesum(above( Num(sum({<Vs={'O'},Year= {'$(=max(Year)-1)'},Month>}
Value/Div)*Var,'#.##0'&'  XT'),0,rowno())))

In my script I have created an Inline table:

Acumulative:
LOAD * INLINE [
Type_cumulative
Normal
cumulative
];

So, I created a filter pane with Type_cumulative Normal - Cumulative.

I have created a Line chart... so What I Want is move the lines according the selection.

I Have tried with:

If(Type_cumulative =Normal , 

(If(VN= '$',
Num(Sum({<Vs={'O'},Year= {"$(=max(Year)-1)"}, Month>}
Value/Div)*Var,'$#.##0;$-#.##0'),
Num(Sum({<Vs={'O'},Year= {"$(=max(Year)-1)"}, Month>}
Value/Div)*Var,'#.##0'&' XT'))),

If(VN= '$',
rangesum(above( Num(sum({<Vs={'O'},Year= {'$(=max(Year)-1)'},Month>}
Value/Div)*Var,'$#.##0;$-#.##0'),0,rowno())),
rangesum(above( Num(sum({<Vs={'O'},Year= {'$(=max(Year)-1)'},Month>}
Value/Div)*Var,'#.##0'&'  XT'),0,rowno())))

But Doesn't Work.

Could You help me in this point?

Thanks!

[Kushal_Chawda · Accepted solution]

try with getfieldselections

Also check the single quotes

If(getfieldselections(Type_cumulative )='Normal ', 

(If(VN= '$',
Num(Sum({<Vs={'O'},Year= {"$(=max(Year)-1)"}, Month>}
Value/Div)*Var,'$#.##0;$-#.##0'),
Num(Sum({<Vs={'O'},Year= {"$(=max(Year)-1)"}, Month>}
Value/Div)*Var,'#.##0'&' XT'))),

If(VN= '$',
rangesum(above( Num(sum({<Vs={'O'},Year= {'$(=max(Year)-1)'},Month>}
Value/Div)*Var,'$#.##0;$-#.##0'),0,rowno())),
rangesum(above( Num(sum({<Vs={'O'},Year= {'$(=max(Year)-1)'},Month>}
Value/Div)*Var,'#.##0'&'  XT'),0,rowno())))