on 01-08-2015 1:40 PM
Hi,
Can I create and execute dynamic formulas in WEBI. For example I have such variable :
= "[Total count] / " + [Dynamic Variable]
[Dynamic Variable] returns a Measure name for example "[Damaged count]". So my variable would look like this "[Total count]/[Damaged count]". However this is just a text. How do I execute it or tell WEBI that treat it as formula and display the results?
Hi
You can´t convert a text to a formula.
You can do like this
[Variable Measure] = If ([Condition1]=1; [Measure1];If ([Condition1] = 2;[Measure2];If([Condition3] = 3; [Measure3];...))...)
[Variable2] =AVG([Variable Measure])
I hope this help you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
try creating a variable that test for which dimension you want,
like [Dynamic Variable] = If ([test] = 1 ; [dim 1];If ([test] = 2;[dim 2];If([test] = 3; [dim 3];...))...)
Cheers,
Rogerio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why would I need to know? [Variable1] provides a measure name to [Variable2] and then it calculates according to formula on that measure that is provided by [Variable1].
Example:
[Variable1] = "Measure1" (The value for this variable changes on certain conditions)
[Variable2] = "=AVG("+[Variable1]+")"
The [Variable2] will return "=AVG(Measure1)". So my question how to tell WEBI that its a formula and not a string?
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.