Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there.
I currently have a situation where I have two dates.
Both are defined by expressions.
First date is made by convertering a string, and adding some conditions to it.
Secound date is defined by today(0)
Third coulum I have is firstdate - secounddate which gives me the difference in days.
Now I only want to show the rows where the difference in days are above 100.
I cannot seem to do a set analysis, because I cannot make a sum, maxstring or whatever out of my dates.
That gave me the same result i had previously where all values become 42460
Dennis,
If you only have three expressions, and the third is the one to check, use
If( Column(3),
...
in the other two expressions.
Ahhh!
So I thought that when counting columns the first dimension column counted as well...Why doesn't it?
Well thank you! that solved the problem!
What if I wanted to make the whole:
=Today(0)
-
date(date#(MaxString({$<[Seneste aktivitet kalenderId]={">$(=0)"},Forløbsstatus={'I gang'}>}[Seneste aktivitet kalenderId]),'YYYYMMDD'),'DD-MM-YYYY')
Into a variabel? I tried to do that, and make an expression saying if(variabel > 100, variabel).
But it didn't work, also changed the checking expression in the other column to put the variabel instead of the long expression.
It might help in other cases just to use this statement as a variabel.
It might work with a variable, but it depends on how the variable is defined an called, i.e. what the scope of the variable evaluation is:
The Little Equals Sign
The Magic of Dollar Expansions
The Magic of Variables
