Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
there is a table with 3 dims: SalesRep, ProductQty, Price. I'm looking for an expression that wil let me get intersection of current selection and bookmark, and be affected by inputfield change - in the below example "John" is a bookmark on John as a SalesRep.
Script:
---------
INPUTFIELD Price;
LOAD * Inline [
SalesRep, ProductQty, Price
John, 10, 7
Mary, 18, 5
];
Expression:
-----------------
SUM({$*John} ProductQty * Price)
Regards,
Przemek
Hi Przemek
You added an expression in your question :
Sum({$*John} ProductQty * Price)
Did you try it and it didn't work ?
It doesn't - expresseion gets unaffected by price (inputfield) change.
Well, I tried it and it seems it is affected by Price Change
Look at my attached file
Change the Price to inputfield in the script and it'll stop.
INPUTFIELD Price;
LOAD * Inline [
SalesRep, ProductQty, Price
John, 10, 7
Mary, 18, 5
];
Still, It is Affected, Just press on the middle or left corner of the field, it will affect only when the field is Green.
We are getting closer and closer 🙂 Change the value to e.g. 12 in the input field (not select) - it won't chane the value of the expression.
Got it now.
It seems like keeps the old value untill you choose it.
I have found a workarround :
Set Price Dimention as following :
If(SalesRep='John', Price, Null())
And Click the checkbox to Supress when it's Null
Hope this workarround is good for you.
The workaround would work if there's few Reps - I got many 😞
Right...
If you add = before the Price Dimention it will work.
See my attachment.