Skip to Content
Author's profile photo AMIT KUMAR

Difference between Webi Formula and variable

Hi All,

I thought to write something which is not covered yet in Google. Lately, while working on a report where one formula is used multiple times an interview question pops up in my mind that what is the difference between formula and variable.

Benefit of variable:

Easy to understand & recognize.

Change is at one place and reflects everywhere in the report.

Maintenance efforts are less in case of future change.

Variable is manadatory to create detail variable.


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Neil Mitchell-Goodson
      Neil Mitchell-Goodson

      Indeed; a variable can simply be a value, such as:


      A formula will usually contain some kind of operator or function.


      Author's profile photo Former Member
      Former Member

      i agree Neil Mitchell

      Author's profile photo Former Member
      Former Member


      Formula once create only Work one Place. formula Not Reusable.

      Variable once create u can can use Multiple places.

      Author's profile photo Former Member
      Former Member

      Hello Amit,

      Just wanted to know like Crystal I don't think we have anything like local global or shared variable that we can refer.

      So how can we call it as a Variable in Webi because like what Niel said if we say =30 is a formula although its an constant.

      Please clarify me on this regards.