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!
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!
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
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
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