This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question
Julie999
New Member
Since ‎07-11-2018
‎05-20-2023

My Stats

  • 7 Posts
  • 0 Solutions
  • 0 Likes given
  • 0 Likes received

datanerd10's Bio

Badges Julie999 Earned

View all badges

Recent Activity

How to divided a measure of type Sum by another measure of type Count

08-09-2018
Hi, I have this measure in a derived table : COALESCE(SUM(CASE WHEN ((DATE(sql_activity_days.sale_date )) - (DATE(sql_activity_days.membership_start_date )) < 122) THEN sql_activity_days.cad_net_invoiced ELSE NULL END), 0) AS “122_days” I want to div...