Hi All,
This i want to acheive dynamically not in script.
Below is the scenario which i want to achieve. i have two input box in which we can set any value.
value from first input box should be multiplied with date1's percentage and value from input box 2 should be multiplied by date2's percentage. output should be (percentage*inputbox1 value) for date1 and (percentage*inputbox2 value) for date2
| date | area | percentage | output | output |
| 1 | a | 0.2 | Percentage * value from inputbox1 | .2 * 4 |
| 1 | b | 0.5 | Percentage * value from inputbox1 | .5 * 4 |
| 1 | c | 0.3 | Percentage * value from inputbox1 | .3 * 4 |
| 2 | a | 0.4 | Percentage * value from inputbox2 | 0.4 *6 |
| 2 | b | 0.5 | Percentage * value from inputbox2 | .5 * 6 |
| 2 | c | 0.6 | Percentage * value from inputbox2 | 0.6* 6 |
| | | | |
| | | | |
| input box1(for date 1) | input box2(for date2) | | |
| 4 | 6 | | |
