datawindow technique

[Former Member]

Hi,

Have across a situation as under. Does datawindow provide a way?

Have a transaction table  as under. While data entry, values F and G under column Spec must be computed as per the given formula. The challenge is that the items in column Spec are dynamic and it comes from a master table. How do i maintain the formula? Is there any datawindow technique can apply here?

Spec	formula	Value
A	NA	6.33
B	NA	5.33
C	NA	3
D	NA	7.16
E	NA	3
F	A-B-C	-2
G	E-(D*2)	-11.32

Thanks

[Former Member]

Hi,

You should be able to use a computed column for column formula:

You need to work out the right syntax but the idea is something like:

if(Spec="F", A-B-C, if(Spec="G", E-(D*2), 0)

It depends if it is a string or numeric result what you should put for NA.

Additionally you can add an expression to make the formula column visible depending on if Spec is either F or G  or if it is not

Ben