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!

• 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

• 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

• 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