Calculation in a view

Hello all.

I would like to make a view, but rather than viewing the actual
content of the record, I would like to calculate the difference
between 2 values (such as the difference of price between 2 products).
I would rather not have to pass through a second table, and would like
to know if it is possible to place the calculation in the creation
sequence of the view.

Many thanks,

Anton

On May 14, 9:16 am, Mad Ant <anton.har...@gmail.com> wrote:
> Hello all.
>
> I would like to make a view, but rather than viewing the actual
> content of the record, I would like to calculate the difference
> between 2 values (such as the difference of price between 2 products).
> I would rather not have to pass through a second table, and would like
> to know if it is possible to place the calculation in the creation
> sequence of the view.
>
> Many thanks,
>
> Anton

Yes.

Did you try it?

Mad Ant wrote:
> Hello all.
>
> I would like to make a view, but rather than viewing the actual
> content of the record, I would like to calculate the difference
> between 2 values (such as the difference of price between 2 products).
> I would rather not have to pass through a second table, and would like
> to know if it is possible to place the calculation in the creation
> sequence of the view.
>
> Many thanks,
>
> Anton
>

yes, certainly you can do this.