syntax error using a variable not an expression

[becki_kain]

I use this expression as, well an expression (column):

round((sum({1<[TP]={$(TP1)}>}Volume)/$(total_sales_vol_tp1))*100,.1)

where $(total_sales_vol_tp1) is a variable which I set instead of defining that as a separate expression (column) and this expression is fine.  but if I replace this:

Round(((AA1/AA3)*100), 0.01)  where AA1 and AA3 are expressions (columns)

with Round(((AA1/$(total_sales_vol_tp1))*100), 0.01)

I get errors in expression even though all the paranthese match up and i'm just swapping in the variable.  what am I doing wrong, as a new person?

thanks

becki kain

[vishsaggi]

May be try this?

Round(((AA1/ '$(total_sales_vol_tp1)')*100), 0.01)

[becki_kain]

with just adding the ''?  nope

'$(total_sales_vol_tp1)'

I still get errors in expression

[lorenzoconforti]

Can you please share how total_sales_vol_tp1 is defined?

[vishsaggi]

Can you share the expressions you are using for AA1, AA3 and your variable expression too.

?

[becki_kain]

=sum({1<[TP]={$(TP1)}>}TOTAL Volume)

[becki_kain]

aa1 is =round((sum({<[TP]={$(TP1)}>}Volume)/$(total_sales_vol_tp1))*100,.1) as a field/column/expression

aa3 is sum(TOTAL{<[TP]={$(TP1)}>}Volume)

variable is =sum({1<[TP]={$(TP1)}>}TOTAL Volume)

[lorenzoconforti]

Try removing the equal sign

[becki_kain]

that's not where i'm getting the error.  i'm getting the error at :

Round(((AA1/$(total_sales_vol_tp1))*100), 0.01)

[lorenzoconforti]

I understand

try removing the equal sign from your variable definition

sum({1<[TP]={$(TP1)}>}TOTAL Volume)

without the equal sign at the beginning