This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
So I have the following columnsToday's DateScope ID (aka a serial
number) I want to filter our rows in a slice based on the following
requirementsToday()-[Today's Date]>=7 daysWe only look at the most
recent [Today's Date] values of each serial numbe...
Hello,I'm trying to limit the sales quantity to less than the current
stock. But I keep on getting an error that numbers cannot be compared to
lists when I use a valid_if statement. Can anyone help? I have tried to
convert the list to a number but ha...
Hello,I wanted to ask if someone could help me out. Im trying to make a
valid_if statement where the time entered must be greater than the
current time minus 2 hours. This is what I currently have and it doesn't
seem to be functioning. TIME([_THIS])>...
So i have a form where you can choose between two options "Remove" or
"Return"Another section of the form ask how much?Is there an expression
to use if the choose the option to "Remove" that the value can either be
0 or a negative value and vice vers...
Did I do this Show_if expression correctly? I only wanted a question to
show on jan 1, jun 6 and dec 12th of every year.
OR(Today()="01/01/",Today()="01/06/",Today()="01/12/")
Hello I tried the following but i'm having no success. There are
multiple copies of the dates for some reason.MAXROW( "Tracker",
"_ROWNUMBER", ([_THISROW].[Todays Date] = [Scope ID]) )
So I tried ANY, but it returns a list of numbers that have sold in the
past rather than the current stock value? A value over the current stock
can still be valid for some reason.
Hello,Its got to stay as enumlist because I have other combinations.
OR([Action]=list("Return"),[Action]=list("Return","Closing
Count"),[Action]=list("Remove"),[Action]=list("Remove","Opening
Count"),[Action]=list("Opening Count"),[Action]=list("Clos...
I keep on getting error?The column type is number[Options] is
enumlistSWITCH function is used incorrectly: Cannot convert input 2 of
type 'Text' to 'List of Text'