Forum Discussion

Nanakwame's avatar
Nanakwame
Icon for Helper II rankHelper II
4 years ago
Solved

Difference between two amounts (Measures or columns)

Hi All,   I am building a dashboard off sales data with sales values, back order amount values, open order amount values etc.  I have a trend graph showing back order amount values and open order ...
Data Protection
General Comment
Show and Tell
Tips and Tricks
Tutorial Requests
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi Nanakwame 

     

    Try this:

     

    Variance = [Back Order Amount]-[Open Order Amount]

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi Nanakwame 

 

Try this:

 

Variance = [Back Order Amount]-[Open Order Amount]

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

 

Nanakwame's avatar
Nanakwame
Icon for Helper II rankHelper II
4 years ago

That worked Sir. What if i wanted to create the percent difference of between the two?

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    Percent Variance =
    Var _Variance =[B    ack Order Amount]-[Open Order Amount]
    return
    _Variance/[Back Order Amount]   //or _Variance/[Open Order Amount]

     

     

    Change the format to percentage. 

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!