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?
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.
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.
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.
