Iโm trying to get the following formula to work so that it builds a list and removes the blanks:
(
LIST(
ANY(Select(Pricelist[โฆ,
ANY(Select(Pricelist[โฆ,
ANY(Select(Pricelist[โฆ,
ANY(Select(Pricelist[โฆ
)
-LIST("")
)
But i keep getting this kind of output:
Iโve tried using Unique(), -LIST(""), -LIST(" ") and changing the list item formula to be
IF(ISBLANK(ANY(Select(Pricelist[โฆ),ANY(Select(Pricelist[โฆ,"")
Nothing works, I always eand up with a leading comma. Which is a PITA because what Iโm trying to do is generate a list of figures, order them low to high, then pick the first item. But this does not work because I always have a leading comma
Anyone any ideas?
Try if statements around your ANY that if the ANY is blank then โValue you cant getโ and then -List(โValue you cant getโ).
I am 95% sure -List() should unique the list. Maybe a bug.
Tried IF(โฆ,โฆ,โFooโ) and then -LIST(โFooโ). Always shows foo at least once
What happens if you remove the -LIST("") away? Does it give you a list correctly?
Removing the -LIST("") make absolutely no difference.
The only thing even slightly unsual about this is the equation is in a โSet the values of some columns in this rowโ action. Which itself is called by an โexecute an action on a set of rowsโ. Everthing about the formula is fine except the -LIST("") not working. So Iโve tried the exact same formula as well as a virtual column. Which works absolutely fine. So must be a bug, Iโll email support@
Perhaps - LIST(DECIMAL(""))
or - LIST(NUMBER(""))
?
The column type is Price, but Iโll try bothโฆ
Wow @Steve your the man!
-LIST(DECIMAL("")) works fine Iโll let support know as its still an issue to me that a virtual column gets a different result from a action formula.
How so?
How do I stop this forum automatically taking out commas etc in a string of text?
Use markdown.
LIST("A","","B","",C","")
should give A,,B,,C,
LIST("A","","B","",C","") -LIST("")
should give A,B,C
LIST(โAโ,"",โBโ,"",C","") -LIST("") in an action formula gives the top (wrong) result as it removes the duplicates but not the blanks. So its not implementing the -LIST("") bit correctly
LIST(โAโ,"",โBโ,"",C","") -LIST("") in a virtual column gives the bottom correct result
Expressions are evaluated by different code in the app and on the servers. Actions are evaluated in the app, but virtual columns are updated in bulk by servers. This appears to be an inconsistency. I urge you to report it to support@appsheet.com.
Its already been reported
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |