Forum Discussion

KAYKAY181159's avatar
KAYKAY181159
New Member
3 years ago

SUB AND GRAND TOTAL ERRORS

While using below formula, I have SUB AND GRAND TOTAL ERRORS. PLEASE ASSIST

 

=IF(
HASONEFILTER('Order Booking - Improved New'[Collection]), -- Check if a single filter context is applied
IF(
COUNTROWS(
FILTER(
ALL('Order Booking - Improved New'), -- Remove any filters on the table
CONTAINSSTRING('Order Booking - Improved New'[Collection], "NOS")
)
) > 0,
SUMX('Order Booking - Improved New', 'Order Booking - Improved New'[ORD ON HAND] * 0.03),
SUMX('Order Booking - Improved New', 'Order Booking - Improved New'[ORD ON HAND] * 0.05)
)
)

1 Reply