IF Statements with more than one condition

Hi


Has anyone done any IF Statements in Wrike Analyze?
We have one set up against our Timelog categories to calculate the chargeable hours & spend.

Originally we had just billable and non billable as we had one rate, however we have had a rate change for new business, so that means I need to have both rates calculated in the report.

Below is our current IF statement with filters on the timelog to only bill if the Timelog is Chargeable.

I've tried to add a new condition, similar as you would in excel but I'm struggling to get it to work.

 

SUM([Task ID],IF((SUM([Total Timelog Time Spent (minutes)]),[Timelog Category])>0,((SUM([Total Timelog Time Spent (minutes)]),[Timelog Category1])/60*160),0))

 

Any help would be greatly appreciated, thanks

Greg

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
1 commentaire

Hi Greg!

Great question. If I understand your need correctly, you would like to have the spend multiplied by 160 for one Timelog Category, and multiplied by a different number for another Timelog Category, correct? In this case, I think just adding the two IF statements together should do the trick. Something like this:

SUM( [Task ID], IF(...)) + SUM( [Task ID], IF(...))

where each IF statement calculates for your specific category.

Let me know if that is what you're looking for! If I didn't understand the question correctly, you can also check out the CASE Function for multi-case IF conditions.

Mark

Mark Tapia Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

Mark Tapia Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: IF Statements with more than one condition
[this list is visible for admins and agents only]

Haut de la page
Didn’t find what you were looking for? Write new post