Gal Posted November 21 Share Posted November 21 Hi Everyone, is that make sense? How can I make it work? Quote Link to comment
Pat Stanford Posted November 21 Share Posted November 21 I don't think IF is a valid Data Tag function value. You either have to use the Trinary function or use a worksheet if. Quote This is a perfect case for the Data Tag version of If/Then, also referred to the trinary operator. Put the result if true before an @ sign and the result if false after a colon (:) and put the test value in the middle. So something like: 'OBS'@#WinDoor 6.0#.#Opaque Glass#:'' So in your case: #∆X#@#∆X#>#∆Y#:#∆Y# Be careful because any extra spaces can impact the operation. Alternatively you could use a Worksheet IF, but I am not certain what you would need to get the ∆X and ∆Y values into the the worksheet format. #WS_IF(condition, Value if True, Value if False)# But you can not use the Data Tag hashtag surrounded format inside the WS function. It has to be pure worksheet definition. HTH 2 Quote Link to comment
Gal Posted November 21 Author Share Posted November 21 Oh, thanks so much! Is that a vectorscrip phrasing? Quote Link to comment
Pat Stanford Posted November 21 Share Posted November 21 No Vectorscript involved. The # (Hashtag) version are pure Data Tag. The #WS_ # version is a Data Tag function that executes Worksheet functions (as if they were in a database row) inside a data tag. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.