This content has been marked as final.
Show 2 replies
-
1. Re: Help needed for condition-based calculated fields
Justin Boschelli Jun 27, 2017 9:48 AM (in response to Mir Jami)I've done this before using LODs I believe. Im not sure if its the best way to go about it, but
'SUM({FIXED [filters/fields applied]: SUM(IF [filter_field] = X then [Y] END)})/SUM({FIXED [filters/fields applied]: SUM(IF [filter_field] = Z then [Y] END)})'
should result in what you're looking for.
-
2. Re: Help needed for condition-based calculated fields
Joe OppeltJun 27, 2017 9:48 AM (in response to Mir Jami)
You can embed IF logic inside your SUM() function.
SUM( if filter_field = X then [Y] END ) / SUM( if filter_field = Z then [Y] END)