Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a Table 1 list box , which not able to display my field S_Price.
I am able to display the value on pivot table 2.
Sorry, i didnt read your issue properly..
open variable overview cltr_alt_v or go to settings>variable overview.
there find out the variable s_price.
click on that variable and in the definition box below paste
=sum(S_Price)
there you go !!
HTH
Sushil
in the number tab.
past this
USD$ #,##0;($#,##0)
HTH
Sushil
Hi Sushi
I try but it still not work. can you pls post me qve file pls.
Paul
Sorry, i didnt read your issue properly..
open variable overview cltr_alt_v or go to settings>variable overview.
there find out the variable s_price.
click on that variable and in the definition box below paste
=sum(S_Price)
there you go !!
HTH
Sushil
Hi Sushil
Thank you it work fine again.
Paul
Hi Sushi
May i know i notice that
for expression :-
sum([S_Price])
for variable
=sum([S_Price])
My question is when to add = sign ? when not to add = sign ? it there a rule on syntax ?
Paul