Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Rather:
=( sum(Time1) - sum(Time2) ) * 4
- Ralf
Hi All,
My problem is solved.
Thank You !
BR
Bhupal