Logical Operators in Zoho Analytics Query
- if_case ( "Customer Address"."Item Wise Weight" > 100, ("Quantity Ordered" * "Weight") * 30) as "Zone Cost"
Hello All,
Requirement is to check the weight of the item and add a custom rate as a different column, but the above query is resulting in the error message "Required parameters missing for the function IF_CASE" .
Is there a correct way to add the ">" operator? What seems to be the reason behind the error?