
1. Re: calculation help
Ken Flerlage Aug 1, 2018 5:18 PM (in response to jon rios)Any chance you can share some sample data or a packaged workbook? It's difficult to diagnose this problem without them, unfortunately.



4. Re: calculation help
jon rios Aug 2, 2018 5:07 AM (in response to tian.yang.4)thanks, I should of been more specific, by isolate, i mean, be able to bring 1 calculation to the shelf as a measure and it shows this particular value. So i assume it has to be a {FIXED} expression, but i have tried every combination and cant get this .1410, if I use this expr. i get Null
{FIXED [Period Date], [Month Qtr], [Benchmark + Portfolio (RS)], [SegmentLabel1], [SegmentLabel2]:
sum (if [SegmentLabel1]= "Now 2 CPD" and [SegmentLabel2] = "Were 1 CPD" THEN [DeltaMetrics]
END ) }
i assumed if i replace this Measure (in this screenshot), with my calculation, i would be the .1410 and nothing else, BUT everything goes blank (NULL)
i tried this adding more filtering conditions, but my quarter date part is incorrect...
{FIXED [Period Date], [Month Qtr], [Benchmark + Portfolio (RS)], [SegmentLabel1], [SegmentLabel2]:
sum (if [SegmentLabel1]= "Now 2 CPD" and [SegmentLabel2] = "Were 1 CPD"
and DATEPART('year',[Period Date])= 2017 and DATEPART('quarter', [Period Date]) = Q3
and [Month Qtr]= "Q" THEN [DeltaMetrics]
END) }


6. Re: calculation help
tian.yang.4 Aug 2, 2018 7:13 PM (in response to jon rios)hi Jon,
I use your formula and it works.
I think the problem is you cannot fix the column which is a measure[Benchmark+Portfolio (RS)]
{fixed+dimension:sum(measure)} the dimension determines at what level measure should be aggregated.
if you problem is still there maybe you can send me the workbook.
YT
