This content has been marked as final.
Show 4 replies
-
Re: total column
JULIAN RODRIGUEZ Feb 27, 2013 3:05 PM (in response to rocha.qkw)What is the expression on each column?
If you are using, for example Sum([Sales]) on Column(1) and Sum([Budget]) on Colum(2), your third expression should be like: Sum(Total [Sales]) - Sum(Total [Budget]).
Regards
-
Re: total column
Dave Everaers Feb 27, 2013 5:41 PM (in response to rocha.qkw)Hi there,
You can just add the 2 columns by this:
Column(5) + Column(6)
greetings, Dave
-
Re: total column
khadeer basha Feb 27, 2013 11:07 PM (in response to rocha.qkw)Hi Rocha,
U can use Coloumn(6)-Coloumn(5)
else
if ur Coloumn(6) expression is named(Name of expression) as Budget and similarly Coloumn(5) as Actual.
if u want to show Budget - Actual
u can use [Budget]-[Actual]
both will give you the same result.
PFA for reference.
-
Community.qvw 136.2 K
-
-
Re: total column
Rob Wunderlich Feb 27, 2013 11:39 PM (in response to rocha.qkw)You are missing a closing paren. But as others have pointed out, the correct syntax is
column(6) - column(5)
No need to incluude sum() function.
-Rob