I need the expression to check the column first, then if it matches (is true) i need the calculation:
IF([Category_Code] = “Accessories”, [Accessories Day Rate] * [Location_Total_Count_Out_By_Category])
This currently gives me the following error:
IF function is used incorrectly:three inputs should be provided — (condition, if-result, else-result).
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |