I have the following expression in my report that is working correctly:
=IIf([product_compare_cost1]<[product_cost] And [product_compare_cost1]<[product_compare_cost2] And [product_compare_cost1]<[product_compare_cost3] And [product_compare_cost1]<[product_compare_cost4] And [product_compare_cost1]<[product_compare_cost5],"BEST","")
what i want to do is to check if product_compare_cost1 is not null. If it is NOT NULL then continue with the above expression ...... I dont know how to work this condition into this expression
=IIf([product_compare_cost1]<[product_cost] And [product_compare_cost1]<[product_compare_cost2] And [product_compare_cost1]<[product_compare_cost3] And [product_compare_cost1]<[product_compare_cost4] And [product_compare_cost1]<[product_compare_cost5],"BEST","")
what i want to do is to check if product_compare_cost1 is not null. If it is NOT NULL then continue with the above expression ...... I dont know how to work this condition into this expression