on 12-11-2007 8:53 PM
Hi Experts -
I have read about this topic in this forum but I'm not making any progress. I need to compare the values of two characteristics (External Material Group and Bill-to-Party). If the values are the same, then I need to produce a report with that information and some key figures.
In some other threads, it was suggested to use a formula variable.
I have created two char value variables using replacement path to get the values of the two characteristics. Now how do I compare this in the formula variable? When I create a formula variable, all I see are the key figures and other formula variables.
Can someone please help me through with this? Thanks a lot!
Hi,after creating formula variables on two characteristics,are u getting values for both? create two new formulas to display formula variable values..and dont forget to place both chars in rows (in drill down) and hide them...
formula 1 = formulavariable1
formula 2 = formulavariable2
compariosn formula = (formula1 = formula2) * KF
KF can be your KF or RKF...whatever it may be.
if formula variables dont return any value,you have to find some other way..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
create a new keyfigure (KF1) with a formula.
Define the fomlula just with one of your two variable (with replacement path) (V1).
Then Use the conditions.
Define the condition like KF1 - equal to - Variable entry.
Here for the variable entry, choose your 2nd variable with replacement path (V2).
Then if you want you can hide KF1,
and the report will only display lines with V1 = V2.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.