Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Id | Product | Total Net | Period (Its a Range belonging to User Input year 500) | Class |
---|---|---|---|---|
1 | A | 10000 | 504.8 | 1000 |
2 | B | 20000 | 504.7 | 1000 |
4 | A | 15000 | 503.6 | 1000 |
3 | C | 25000 | 503.4 | 1000 |
5 | B | 25000 | 502.3 | 1000 |
6 | C | 30000 | 501.8 | 1000 |
7 | A | 20000 | 500.7 | 1000 |
8 | B | 25000 | 500.1 | 1000 |
9 | C | 35000 | 499.8 | 500 |
10 | A | 25000 | 498.6 | 500 |
12 | B | 30000 | 498.1 | 500 |
13 | C | 15000 | 495.2 | 500 |
This is a sample data from my project.
I have User Input Box with Variable vYear . If I enter 500 then I get the nearest Max possible value near 500 which is 501.8 and nearest Minimum value Min possible near 500 which 499.8 in a Text Box.
Now, I have a code in my script editor.
NewClass:
Load * Inline{
Min, Max, Classss
1001, , <unknown>
500,1000,1000
250,500,500
100,250,250
50,100,100
,50,50
};
IM:
IntervalMatch(Period)
Load Min,Max Resident Newclass;
So now,
Whenever User inputs vYear = 1000 / 500 /250 /100 /50 in Input Box; my calculations should be like Total Net * vYear but vYear means Nearest Possbile Max and Min. I have to show this in Line Chart.
Dimension - Classs where on X-axis I will have 1000,500,250,100,50 and corresponding values of Nearest Max and Min on Y-axis i.e. Expressions..
How to associate this Classs with the Calculations??
I am very confused. Please help.
Thank you everyone in advance.
Would you be able to share a sample where you have been playing around with this? It would be easier to look at what you have and carry it forward
Will send the screenshots and codes.