Good day to all in the community.
I have a situation where I need to calculate a Cost / Lbs and a Cost / Mile based on the transportation mode I am using.
if I use parcel: I need to calculate the cost / Lbs and this is this value that needs to be displayed.
If I use Full Trailer loads: I need to calculate the cost / mile and I need to display this value.
Below the desired result (a blank or - in the cell where the calculation is not replevant or does not apply)
Jan | Feb | Mar | Apr | May | ||
Trailer Load | Cost/Lbs | - | - | - | - | - |
Cost/Mile | $ 0.50 | $ 0.60 | $ 0.10 | $ 0.30 | $ 0.50 | |
Parcel | Cost/Lbs | $ 1.00 | $ 1.10 | $ 0.90 | $ 1.20 | $ 0.90 |
Cost/Mile | - | - | - | - | - |
Has anyone done this type of calculations:
- Testing the mode (An alphanumeric value); care to share an example for me to try to reproduce?
- Triggerred a calculation based on the mode;
- Display or not the value if relebant or not (here for instance show nothing for cost per Lbs if mode is FTL
Any help, advice or direction is greatly appreciated.
Try the below syntax
[Cost]/( If [Column]= "Parcel" then [Lbs] else [Mile] end )
Best Regards
Laxman Kumar