Forum Discussion
_anomDiebolt_
7 years agoQrew Elite
You need to divide the range of min and max days into disjoint non-overlapping intervals that covers all possibilities.
Try this:
Try this:
[Rental Days]
*
If(
[Rental Days] <= 3, [Rental Item - Daily Rate],
3 < [Rental Days] and [Rental Days] <= 24, [Rental Item - Weekly Rate],
24 < [Rental Days] , [Rental Item - Monthly Rate]
)