0

Calculating Target Difference

Hi, I've created a Klip with a table displaying sales per sales person for each month of the year.

For some reason I am having an issue calculating the difference in sales to target.

What would be the best way to get the calculation of the difference of the Sales for each month and the Target? See screen Grab.

 

Thanks

4 comments

  • 0
    Avatar
    Meggan King

    Hi Dom,

    What formula are you trying currently and what isn't working? You should be able to reference the Target and the Sales column, or you can create a hidden column, repeat the Target value for every sales month and then do your formula to find the difference. 

    If you'd like us to look more closely, you could open a support ticket by emailing the team. 

    Thank you

    Meggan

  • 0
    Avatar
    Dom Oldham

    Hi, I'm trying this ARRAY(!Target Value - @B:B)

    I'm trying to add all salesperson targets into the table(See Image 1) but I can't seem to do it.

    Then I want to find the difference between the 'Target' and 'Sales" and then display it like (Image 2 attached)

    Thanks for your help

  • 0
    Avatar
    Meggan King

    Hello,

    To be more specific in our help, you should please open a support ticket and we can work directly in your account. At a high level, it would be something as simple as a formula using results references like:

    &Column:Sales - &Label:Target

    You should not need an ARRAY column since you already have the data displayed in your Sales column and the Target in the label. If you are going to include indicators, you will need Hidden Data and repeat the Target value using the REPEAT function. 

    You can open support tickets from the 'Support' subheading at the top of the page in the navigation bar, or send an email to support @ klipfolio. com

    Thank you

    Meggan

  • 0
    Avatar
    Dom Oldham

    Thank you.

     

Please sign in to leave a comment.