cancel
Showing results for 
Search instead for 
Did you mean: 

Query to Multiply values that is not saved in the DB

Former Member
0 Kudos

Hi guys,

Can anyone tell me is it possible to do arithmetic operations over two values in a form,before saving to the DB?

ie,for example,I want to multiply the "items per Unit" value and "Unit price",which is not saved in the DB, and fill it in a user defined field.

Is it possible?If yes how will be the Query to be written?

Expecting faster replies....

Thanks in advance

Akhin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Akin,

Yes you can achieve this with applying a  Formatted Search on your User defined field.

SELECT $[$ RDR1.Quantity] * $[$ RDR1.Price] FROM RDR1

You can modify this query according to your need.

Regards

Former Member
0 Kudos

I tried this formatted search before,but not working well.

Actually one of my value is in a variable and not in a field which has a reference like "RDR1.Quantity".

What should be done in this case???

Former Member
0 Kudos

Hi,

For variables you can write like :

$[$ 38.11.Number] this is same as $[$ RDR1.Quantity]

for your variable :

$[$ 38.YourVariable]

Regards

edy_simon
Active Contributor
0 Kudos

Hi,

by Pari's solution :

$[$ 38.YourVariable]

38 is your ItemUID which is the matrix document detail lines.

YourVariable is your the column UID in the matrix

Regards

Answers (0)