what are these? when do you use them? why one over another? thanks
Data types
string
long
float
bool
date
datetime
datetimetz
Data Type
Description
Used for storing text, such as names, addresses, or any other sequence of characters.
A numeric data type for storing large whole numbers.
Used for storing numbers that have a fractional part, also known as floating-point numbers.
A data type that can only hold two values: TRUE or FALSE.
Used to store a date (year, month, and day).
Used to store both a date and a time of day (year, month, day, hour, minute, second).
Similar to datetime, but it also includes information about the timezone.
We have a question regarding the behavior of the XL3dowriteback formula. Our understanding is that this formula allows writeback to be controlled on a cell-by-cell basis. In our operation, when we need to clear a previously written-back value due to an input error or similar reason, we do so by entering 0. However, when…
We added new bed types to eventually move from the old "All Beds, single, double" I inputted the data into the new bed types Went to double check flow into other modules and found that they are being double counted even though I blanked the original columns out. I am not sure why it is still counting All Beds even if it is…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
