Some questions about how can i use the functions "if" & "and"

[ChrisRafer5]

So i got this table, with time value in it, and i need to get the SUM and the AVG of them, nonetheless the problem start when its a service time, so some services got no time, because people call at indevide times and it gets the "null" mark. And because of this, the final logic gets broken. And of all it, the system counts some of this services as "closed" and others as "open", because the closed ones gets generated by the bot of people calling at non working times, and the opened because actual employees forget to close it.

So my question is:

How can i make a time reduction column based on 

if the column "time of service" has the value "null", and the column status has the string "Open", then return "time of creation (of the service (this is another column in question)) - today date(already generate a column that display todays date) else "time of service".

if any type is dosent make sense please tell me and i will try to explain further, english is not my first language.

[parry2k · Accepted solution]

@ChrisRafer5 let's start with this, add a new column

--if actual typed value is null use this
New Col = if ( Table[TimeofService] = "null" && Table[Status] = "Open", [Time of Creation] - Today, [TimeOfService] )

--if value is blank use this
New Col = if ( ISBLANK ( Table[TimeofService] ) && Table[Status] = "Open", [Time of Creation] - Today, [TimeOfService] )


 

[ChrisRafer5]

Thanks! It worked Just as intended, a life sevior 🙏