Search results for query: *

hi lb! i created a formula (@negate): if {transaction.transact} = "red" then (-1*({transaction.amount})) else {transaction.amount} and used @negate to column & summary data which showed the difference in the total column (which is the net sales). however, i would like to sort the total...

thanks lbass & lb for your help. however, i found a way to solve it. i created a formula converting the redemption column into negative values and using it as summary values, thus the total resulted into difference. after which, i formatted the negative values to not show the negative sign...

Hi guys! thanks for the replies. however, i just can't seem to let it work. the sub & red are sum totals of subgroups. i used txns field in as column header in order to segregate the sub & reds in two columns from a single field. after which, i would like to have the difference of the sub from...

thanks ian. but i forgot to say that the red & sub amounts are records inside 1 field "TXNS" which i took the group sum and are showing in the cross tab.

Cross Tab : sub red total a 200 50 250 b 300 100 400 c 400 200 600 d 500 300 800 total 1400 650 1950 values from red & sub are all group sum. now, instead of getting the rows total, i would...