Hey all,
I'm stuck at the following problem: I have date values (month and year) on the x-axis and some Sum formula with a set expression as my measure in a bar chart.
Now, this chart always show...
...CurrentID01', 'vCurrentID02', etc. for all KPIs. The problem is that if I try to use the result as a variable by defining another measure having the function like =$(=$(='vCurrent' & $(='$(vKPI)'))) I...
...ll created Excel styled spreadsheet using Valuelist as a dimension and PICK MATCH in the expression in order to achieve the cell level control as it is in Excel. However, this becomes hard to read a...
...ne dimension with several values. Variable contains: =getfieldselections(Item) =vRelativeSelections pick(match(Item, '=$(vRelativeSelections)',red(),Yellow(),black())) Thanks is advance.
I have a formula that is taking quite some time to evaluate. Based on the result I want to display a different message. Is there a way to store the result in a local variable to use within the f...
Hi, today I am stuck with a special set analysis. Out of a list of technical solutions, I have to pick the smallest version that just satisfies the demand. All this of course has to take place in a...
Hi all,
I wanted to give a try to the feature in Gitoqlok that allows to share script sections and sheets between apps.
To do so, I set up a remote environment for git repositories at Gitlab. Ins...
Hello Everyone, Say I have the following data set called "Data": 1, 2, 2, 2, 4, 4, 5, 6, 6, 8. When I use Max(Data, 1) I get 8. Max(Data, 2) = 6, BUT Max(Data, 3) = 5. This makes sense, but I wante...
Hi community,
I struggle with the attached load script, which is not working as expected although I tried to base it upon the example in the online help.
For some reason the Evaluate(FORMULA) ret...
Hi,
I'm actually going mad at this stage trying to figure this out. I'm trying to build a set condition that will just include where a date is between two other dates. I've tried both of the ...
