Variables

[#1]

Hi,

I'm working on a dashboard and created a table  in the visualizations.

I created variables and used them in my table.

If the content of my variable is:  round($(vTotal Revenue)/Count(DISTINCT(if([Billing Period] >= Parcel_Signature_Week,([Billing Period]))))*52,1)

I get a different result  if the content of my variable is: =round($(vTotal Revenue)/Count(DISTINCT(if([Billing Period] >= Parcel_Signature_Week,([Billing Period]))))*52,1)

The formula itself is correct.  The = sign seems to be what causes the difference in results within my table.

Can someone explain why I get 2 different results? Why does adding the equal sign change the output?

Thanks!

[its_anandrjs]

Better you can use this expression on variable

round($(vTotal Revenue)/Count(DISTINCT(if([Billing Period] >= Parcel_Signature_Week,([Billing Period]))))*52,1)

and then use variable in expression because when using AGGR key words with expression (SUM,COUNT,AVG...) equals sign by default puts above the expression.

Ex:-

Expression =$(vSum)

[andrei_delta · Accepted solution]

Hi Cindy,

When you are NOT using the "=" sign when writing a formula in the variable and then you call it in a chart, that's the moment when it gets evaluated.

When Using the "=", the variable already evaluates the expression and gets you a result (and from what i've seen the result is like a total or average of something, depending on your formula)  and when you call it in the table it brings you one value for the whole dimension.

I hope it helps!

[#4]

Exactly the explanation I was looking for,  THANK YOU!!!!!!