Skip to Content

Conditional Calculated Measure

Mar 03, 2017 at 10:18 PM


avatar image
Former Member

The raw data that I am pulling into Lumira has a YTD sum of units sold as one of the measures. This data is published quarterly. What I want to do in Lumira is:

adjusted qty = If quartermonth = 12 then qty(quartermonth(12)) - qty(quartermonth(9))

What I'm getting at is having Lumira calculate the quarter's actual quantity instead of the running sum that it is giving me.

10 |10000 characters needed characters left characters exceeded

What about breaking up the calculations?

What is your data source? If it is a BEx query it is better to do the calculations in the query

* Please Login or Register to Answer, Follow or Comment.

0 Answers