on 08-17-2007 2:06 PM
Hi,
Im am using a query on AR.
I would like to exclude lines for which posting date of the FI document is equal to the clearing date of the FI document. The two caracteristics are available, but I dont know how to use them ?
thanks
J
Hello Ja,
I reccomend you to find a certain characteristics value when those two is same. And then try to filter it in query definition. For example, when those two is same document type might be 'XXX' or another field might be a certain value.
Sarhan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Create formula variable with processing type Replacement path for each date and you can use those variable to make a comparison in your report using formula. When creating the variable use Key and also the type should be date.
Let me know if you still need anything on this.
thanks.
Wond
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You do that in the query level at runtime.
1.Create a new Calculated key figure, in the window to create calculated key figure, you will see formula variables.
2.Create a new formula variable, select your object (the date you want to create on)
3. Specify at a key and processing type as replacement path
4. then you have done one and keep it as calculated key figure and do the same for the second date.
5. Now you can create formula on both calculated key figures.
thanks.
Wond
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.