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.

    michel.khennafi

      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.