Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
no existing value or 0 ??
Hi,
when i use dataa fonction, the result is 0 even if the data doesn't exist.
What is the difference with the value 0 ??
Why do the fonction not return a NULL value or anything else ?
How can i make this difference ?
regards.
no answer ??
even if it is a bad answer ...
An empty numeric cell has the value 0. That is why zero is returned.
Even if the cell is not numeric, the value is 0.
and, i use the SDK PHP, so i don't use Excel. And the value is always 0 ...
Can i know if the value is missing OR if the value exists and is 0 ?
I'm not sure how you get a zero for a non-numeric cell. I have a cube that has two measures: sales rep bookings (numeric) and a comment (string). When I display the two measures, the comment is always blank unless a comment has been entered.
When you right click on the element, does it have a checkmark beside "numeric" or "string"?
I have only numerics values.
(OK i did'nt make all tests in Excel, i don't have string values)
but how can you know if the value is missing with numerics values ?
----
Did anybody meet this problem with PHP ?
(the fonction PHP "palo_dataa" return 0 even if the value doesn't exist.)
Even i face the same problem in exce. I am not able to distinguish between missing values and zeros in my spreadsheet. Is there a workaround for this.
Dear Palo programmers!
Is there any solution of howto mark empty cell of numeric type?
Let us imagine parameter "Days to End of the World" is unspecified, what is shown? ZERO!!! Feel the difference???
