How to write the Expression for Subtraction and multiplication?

[Anonymous]

Hi Community,

I am facing the same problem in my development, but i need to subtrct the two row from different columns in the same table.

Example:

Time 1 Time 2

3 2

6 3

Tatal 9 5 =4 (9-5)

Can you please suggest how can i write expression for 9-5= 4 and Multply 4 with some other number like 4*9=36.

Thanks

Bhupal

[#2 · Accepted solution]

Hi Bhupal,

You can use total function i.e

Total(Sum(time1))- total(sum(time2)

and for the multiplication with other number

Total(Sum(time1))- total(sum(time2) * 4 (any number you wnat)

[anbu1984]

Substract 2 different rows of a single table

[rbecher]

Rather:

=( sum(Time1) - sum(Time2) ) * 4

- Ralf

[Anonymous]

Hi All,

My problem is solved.

Thank You !

BR

Bhupal