I'm looking how to calculate multiple rates based on the following criteria:
Pricing is as follows: 1st unit gets mileage fee. Mileage fee is good for up to 4 units then the mileage is added again.
1st Unit: ((2*[miles rounded]+50+1.5)*1.10)
2nd Unit: $50
3rd Unit: $50
4th Unit: $50
5th Unit: ((2*[miles rounded]+50+1.5)*1.10)
6th Unit $50
and so on...
I have this expression so far but it's not helping with the units that are charged mileage..
IFS( COUNT(SELECT(Rented Equipment[Location], AND([Rental Type]="PJ", [Location]=[_THISROW].[Location])))>1,$50,
[Rental Type]="PJ",((2*[miles rounded]+50+1.5)*1.10))
Any thoughts?
If you could make your requirement clearer, perhaps a better suggestion can be there.
Is it correct understanding that
A) if the count is 1 or 5 then only apply the expression ((2*[miles rounded]+50+1.5)*1.10) and for all other counts just show $50
or
B) would you like summation as well. So if count is 3 then ((2*[miles rounded]+50+1.5)*1.10) +100 ( for count 2 and 3) , if count is 4 then ((2*[miles rounded]+50+1.5)*1.10) +150 ( for count 2, 3 and 4) , if count is 5 then ((2*[miles rounded]+50+1.5)*1.10) +150 + ((2*[miles rounded]+50+1.5)*1.10) and so on
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |