Firstly thanks for taking the time to respond.
In simple terms Im trying to do the following.
The user enters a numeric value and a typing, For Example "3" and "Cars".
In another Table we hold another Typing and Numeric value that relate to this in someway, for Example "Cars (diesel)" and a numeric value of "1.25".
Because of how our system is set up I have to manually link the two sets of data together to get a conversion rate.
So IF TYPE = CARS THEN CALCULATE 3 MULTIPLIED BY THE NUMERIC VALUE(1.25) LINKED TO CARS (DIESEL)
I only want to multiply the number the user enters by the numeric number in my other table based on what I filter it by.
Hopefully that makes sense.
Your use case is not fully clear to me.
Could you please elaborate around what you mean by "The user enters a numeric value and a typing, For Example "3" and "Cars". "
More specifically:
- Which user? (viewer? designer?)
- Where he is going to type a value? In the cube? Within an input in the dashboard? If so - which input?
Even though I'm not fully understand the user case, from the sentance below it sounds like you'll need to do some JS to do what you're looking for as you wish apply logic that is baes on a user selection rather then the data model.
"I only want to multiply the number the user enters by the numeric number in my other table based on what I filter it by."
If you wish, we can hop on a quick call to review and guide you on your direction or provide you with a quote to achieve what you are looking to do.
Looking forward,
Ravid
Paldi Solutions | Sisense Experts for Embedded Analytics Tools
