I am trying to use IFS in my expression but i am getting a parentheses error. I am unsure what i am doing wrong:
My Expression:
IFS(
[TYPE] = “Trailer”,
concatenate("Name: “,[ASSET NAME],”
Asset ID: “,[ASSET ID],”
GPS TAG #: “,[GPS TAG],”
Work Order: “,[Work Order ID],”
Customer: “,[NewComputedkey].[Customer_Name],”
Plate Renewal Status: “,[Plate Renewal Status],”
)
,
[TYPE] <> “Trailer”,
concatenate("Name: “,[ASSET NAME],”
Asset ID: “,[ASSET ID],”
GPS TAG #: “,[GPS TAG],”
Work Order: “,[Work Order ID],”
Customer: “,[NewComputedkey].[Customer_Name],”
Plate Renewal Status: “,[Plate Renewal Status],”
Primary Air Filter: “, [Primary Air Filter],”
Secondary Air Filter: “,[Secondary Air Filter],”
Prim Fuel Filter Water Separator: “,[Primary Fuel Filter Water Separator],”
Secondary Fuel Filter: “,[Secondary Fuel Filter],”
Oil Filter: ", [Oil Filter])
)
Solved…
User | Count |
---|---|
43 | |
29 | |
22 | |
20 | |
13 |