ifelse(
isNotNull({DATE}),
{DATE},
ifelse(
contains({Metrics}, “Base”),
concat(“(”, toString({Integer}), “)”),
concat(toString({Integer}), {SIG})
)
)
showing error
error in the lasr line
You need to convert the second {DATE}, can you try using something like a to_string ({DATE})?
I was not looking at the actual data or function, just to get the calculated field work.
If you can give us some example data from your table I can try to take a look.
sure…
this is data in label column date datatype and interr data type both present so i break it into 3 columns- date is manually converted into integer… 2-one is the integer column and 3rd one is sign like ABC Kinda
for this i want ifelse statemnet like if date column is empty then take interger column value and in interger also there is condition if metrix name is base then add () this to number and if in sig column if albhabet is present then add that albhabet into it
I am sorry, I do not understand what you are trying to achieve, I also do not see a column named Metric in your screen shot. Is it possible for you to create a simple CSV with the 4 columns you want to use in the calculation and what is your expected value, please cover as many cases as possible so we can understand better what you are trying to achieve.
e.g.
DATE, Metrics, Integer, SIG, expected
20240911,123,456,-,xxxxx
Thanks.
sure i m sharing u a sample data sheet…
for better understanding i m simplyfying my requiremnet …in label colum - date and integer data type is present- so i simply break it into 3 coulm- date, integer and sig
if date is blank it check integer (with condition check if metric coulm name startes with base the add () into integer coulm otherwise simple concante integer and sig…
i want in pivot table data should come as it is given in label
I see no problem in the result of the ifelse statement with the changes I suggested in the calculated field.
For the pivot table, we do sums or counts, I do not know how to get that output you show in the table as a pivot.
I will recomend opening a new question related to the possibility of showing the values of a calculated field in a pivot table to see if anyone in the community has an answer specific to pivot.
Good luck!
1 Like
continously showing error one more thing i want the date should in date formate in final result
You can try using parseDate
showing error in parsze date as well