I have a query with me which should be implemented in tableau ,
100 * SUM(customer_product_orders.cm0) /
(CASE WHEN SUM(customer_product_orders.gross_revenue) > 0
THEN SUM(customer_product_orders.gross_revenue) ELSE NULL END
how can i write this in tableau syntax any help would be appreciated as i am new to tableau.
You can try below syntax:
100 * SUM([customer_product_orders.cm0]) /
(IF SUM([customer_product_orders.gross_revenue]) > 0 THEN SUM([customer_product_orders.gross_revenue]) ELSE NULL END)
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...