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