Solved: How to write a fixed currency value in expression - Page 2

Maple_Aikon · 03-10-2021 02:00 AM

Hi, I have a [ItemPrice] Column that is price of item. How can I run this expression without error:

MAX(LIST([ItemPrice], 0))

It show error “LIST has elements of mismatched types”. That’s because 0 is Decimal and [ItemPrice] is Price. So how can I use a fixed value of Price type. I’ve tried “$0” or “$0.0” or “0.0” but useless

Maple_Aikon

The first way is no use, the error LIST has elements of mismatched types is still there. But the second way is working. thanks for your help Steve

View solution in original post