Sathish_Kanna Member

Comments

  • CASE WHEN Parent Expense Category Name= 'P-CARD' THEN SUM(Transaction Amount) END this formula gives me the sum at a total level. IN the pivot table I have the business segment and the function for which the individual values do not show up. So basically I want the expense category numbers total by Business function level…
    in Sum of Specific Expense Type Comment by Sathish_Kanna October 2023
  • In this case lets say the booking date is 1 October and the shipment date is 15th November then will the output be the Shipment dollars? Should I load a date mapping file to get the output?
    in Booking date and shipment date formula Comment by Sathish_Kanna October 2023
  • I have two columns. One is the Booking date and the second is the shipment date. IF the Booking date and the shipment date are within the same quarter then give me the Shipment dollar for the Order number.
    in Booking date and shipment date formula Comment by Sathish_Kanna October 2023
Default Avatar