1 Reply Latest reply on Mar 13, 2015 7:07 AM by Tableau kumar

If statement to determine if a field can be displayed AND the type of calculation.

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.

• 1. Re: If statement to determine if a field can be displayed AND the type of calculation.

Try the below syntax

[Cost]/(  If [Column]= "Parcel" then [Lbs] else [Mile] end )

Best Regards

Laxman Kumar