Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Please correct me IF condition

Hello Members, Please let me know is my below IF condition is correct / wrong. I am finding Totalminute between Issue Detection Time & Incident Start  which is generated by name XYZ   if [Triggered...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try soething like this

    if [Triggered XYZ] = 1 then
	if [#" Detection Time (UTC)"] < [#"Incident Start (UTC)"] then
	Duration.TotalMinutes([#"Detection Time (UTC)"] - [#"Incident Start (UTC)"])
	else
	Duration.TotalMinutes([#"Incident Start (UTC)"] - [#"Detection Time (UTC)"])
else
	"null"

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try soething like this

if [Triggered XYZ] = 1 then
	if [#" Detection Time (UTC)"] < [#"Incident Start (UTC)"] then
	Duration.TotalMinutes([#"Detection Time (UTC)"] - [#"Incident Start (UTC)"])
	else
	Duration.TotalMinutes([#"Incident Start (UTC)"] - [#"Detection Time (UTC)"])
else
	"null"