I have list box: Name is Text and Option is 1M$, 2M$ and 3M$.
Now If User Select 1M$ then I need amount, which is greater than >1M$ from my records. Else By default, If Not selection is there – then 0, If user select 2M$ then greater than >2M$ from my records and when user select 3M$ then greater than >3M$ from my records and By default 0.
Below is my expression where I want to add this condition.
My selection -->VSelection1--> I have selected Jan 2019 andVSelection2--> I have selected Feb 2019 Below my Straight Table whereVariance1--> is VSelection1selection data and Variance2--> is VSelection2selection data and Variance --> isColumn1- Column2 (Output).
I haveOption1 Radio Button for Millions (M) and Full Value(##,###,##)andOption2 Radi Button for Yes or No Selection(Exclude IFRS Group options).
These are the parameter I have used and my expression logic is working properly. Expression is below:
Now I want one more condition that is onText Dimension --> 1M$ / 2M$ / 3M$--> Bydefaultit is not selected, But If I select 1M$, From the straight table (Greatter Than)>1M$Value should to display in straight table. If I select2M$, From thestraight table >2M$ Value should to display similarly for 3M$
ForThreshold OptionsI have done the script --
Threshold: Load * Inline [ Text, Value '1 M $', 1000000 '2 M $', 2000000 '3 M $', 3000000 ];
So team can you help me on this. Thanks for help in advance