0

subtracting a fixed value from output

Hi!

I'm new to Klipfolio and I need to subtract a fixed value from all output values.

How can I do this?

Any help is greatly appreciated!

3 comments

  • 0
    Avatar
    Janice Janczyn

    Hi Peer and welcome to Klipfolio!

    If the fixed value is a number, you can simply subtract it from the results of your formula. For example, if your formula is GROUPBY( @A:A, @B:B ) and you want to subtract 25 from all the values, you can use:

        GROUPBY( @A:A, @B:B ) - 25

    If the fixed value is set by a variable or user property, you can subtract that from your formula:

        GROUPBY( @A:A, @B:B ) - $varName

    I hope this helps. If it isn't quite what you're trying to do, please provide further details or email support@klipfolio.com. We're happy to help!

    Thank you,
                  Janice

  • 0
    Avatar
    Peer Christensen

    Hi Janice,

    thank you for your help! I really need to get started on the courses/tutorials.

    I'm still struggling with the following code that my predecessor wrote:

     

    Lookup(CONCAT(CONCAT("0",slice(@A:A;,60+date_UNITVALUE(today(),"45"))),CONCAT("0",slice(@C:C;,60+date_UNITVALUE(today(),"45")))),CONCAT(CONCAT("0",slice(@Sheet1,B:B;),CONCAT("0",slice(@Sheet1,A:A;)))),slice(@Output,F:F;))/100
    *
    Lookup(CONCAT("0",slice(@A:A;,60+date_UNITVALUE(today(),"45"))),CONCAT("0",slice(@Sheet1,A:A;)),slice(@Sheet1,B:B;))
    +
    Lookup(CONCAT("0",slice(@A:A;,60+date_UNITVALUE(today(),"45"))),CONCAT("0",slice(@Sheet1,A:A;)),slice(@Sheet1,H:H;))
    *1/COUNTIF(slice(@Output,B:B;) = DATE_UNITVALUE(today(), "3"))

    I've tried implementing your suggestion, but failed to do it correctly. Basically, from the output of the above code.

    Do you know how I need to modify it in order to subtract e.g. 25 from each value?

     

    Thanks!

    Peer

     

  • 0
    Avatar
    Janice Janczyn

    Hi Peer,

    It's difficult to understand what this formula is trying to do without seeing the data. I suggest you email support@klipfolio.com with a description of what this formula is intended to return and enable support access to your account so we can take a closer look.

    Thank you,
                Janice

Please sign in to leave a comment.