...
When you will use this new measure Profit in your eazyBI flex.bi reports then for any combination with other dimension values this formula will calculate a difference between a Store Sales measure value and a Store Cost measure value.
...
Time difference calculations
eazyBI flex.bi defines an additional function DateDiffDays(from_date, to_date) which will return a difference in days between two dates. It can be used together with Now() function (which returns the current time) to get a distance in days between selected Time dimension member and the current date, for example
DateDiffDays([Time].CurrentMember.StartDate, Now())
In addition eazyBI In addition flex.bi defines a function DateAddDays(date, number_of_days) which will return a new date in the past (if number_of_days is negative) or in the future (if number_of_days is positive). For example, this will return a date which is 5 days from the current Time dimension member date.
...
Sometimes it is useful to get the Time dimension member which corresponds to the actual current date. This can be done with eazyBI flex.bi specific dimension hierarchy level property CurrentDateMember. For example, these expressions will return the members for the month of the current date and the week of the current date:
...
There is also an additional eazyBI flex.bi specific dimension hierarchy level method DateMember for which you can provide a dynamic date expression argument and get the corresponding member (or the last period before that date which is present in the Time dimension). For example:
...