on 09-21-2006 2:40 AM
Hi gurus...i was wondering if it is possible to calculate periods of time between 2 time characteristics, i mean to create a formula or a calculated key figure based on that two time characteristics.
Example:
i have ztime1 and ztime2 each one with specific dates and what i want to do is to do a formula like:
ztime2-ztime1 = x days
is it possible to do it at the BEx?
Thanks
You can try this -
Create formula variables of replacement path type (replaced by key value of respective date chars).
Now create a formula with these (with the function that treats these as dates, so you get the right calculation), and finally apply a NODIM if needed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.