Calculation within Tables

[AmCh]

Hi all,

I have the following table (Input) as an example:

a	b	c	d	e	f	h	i
1	6	0	1,1	2,1	0	0	9
2	0	0	2,3	3,2	1	29	5,8
3	0	0	3,4	4,3	0	1,25	0
4	0	0	4,5	5,4	0	3,33	0
5	0	0	5,6	6,5	1	0	2,43
6	0	1	6,7	7,6	0	0	24,56
0	0	0	0	0	0	0	0

Desired intermediate output (Table):

respecting those formula:

j=m*c (m: entered value from the user with an input box)

k=n*d (n: entered value from the user with an input box)

l=e

vMAX=MAX(j,k,l)

respecting this formula, desired first output looks like:

P[i][t]=(vMax*t-x)(1-f)+(((t-(1/vMax))/o)+1)*f // x=0 if t=o else x=0,001

i/t	1	2	3	4	5	6	...	o
1	P[1][1]
2
3
4							P[i][t]
5
6								P[6][o]

respecting to this formula, second desired output looks like:

q

SUM(h*Transpose(P[1][t])

SUM(h*Transpose(P[6][t])

Any Help please?

Thanks in advance

[edwin]

@AmCh not sure what is wrong with your chart.  maybe you can attach your QVW?

[edwin · Accepted solution]

this is what i did

[AmCh]

It works perfectly!
Thank you!

[edwin]

yw