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.

Amit

Assigned Tags

      4 Comments
      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:

      =30

      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

      Hi,

      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.

      Thanks

      Niraj