-
1. Re: LOD with If statement
Justin Larson Apr 20, 2017 10:04 AM (in response to Nathan Flanagan)2 of 2 people found this helpfulnot so far off:
{ FIXED [ID]: avg(IF ISNULL([Clear Dt]) then [Total Cost] end ) }
-
2. Re: LOD with If statement
Deepak Rai Apr 20, 2017 10:05 AM (in response to Nathan Flanagan)Hi Nathan,
Your calculation is Correct. Just Change your SUM to Avg in the Text Label. Right Click>Measure>AVerage.
Thanks
Deepak
-
Example.twbx 17.7 KB
-
-
3. Re: LOD with If statement
Justin Larson Apr 20, 2017 10:34 AM (in response to Deepak Rai)@Deepak Rai, if he does this and then pulls Id off the shelf, the result is 6648, which I do not believe is what he's after.
-
4. Re: LOD with If statement
Deepak Rai Apr 20, 2017 10:39 AM (in response to Justin Larson)Hi Justin,
In his LOD , his intention is to FIX it to ID, So pulling off IDs from Rows doesn't come into Picture. That would be a different scenario.
Thanks
Deepak
{ FIXED [ID]
-
5. Re: LOD with If statement
Nathan Flanagan Apr 20, 2017 10:44 AM (in response to Deepak Rai)Thanks for the help!
Okay, I don't think I explained my self well enough.
So, we have more one with multiple id's with on price. And we have another Id with a different price. The price will repeat for the same id. There fore I want to find the average of each id. Then I want to find the sum of those.
Since there is one Id with an average of 11 thousand. And an Id with 8 rows of 6 thousand each. I want it to return one one row of 6 thousand and one row of 11. So when I sum it up it will equal 11 thousand.
Does that make sense?
--
Nathan Flanagan
-
6. Re: LOD with If statement
Justin Larson Apr 20, 2017 10:52 AM (in response to Nathan Flanagan)That's how I understood your original post. See the alteration in my original reply. Should do the trick.
-
7. Re: LOD with If statement
Nathan Flanagan Apr 20, 2017 1:13 PM (in response to Justin Larson)Justin,
That worked perfectly!
Thanks so much,
-Nathan Flanagan