Hi CodePeople,
I have a calculated field (fieldname2) that either shows a number with % or a number with €:
IF(fieldname1==1,FORMAT(fieldname18, {prefix:””, suffix:”%”, groupingsymbol:”.”, decimalsymbol:”,”, currency:false}),
FORMAT(fieldname18, {prefix:””, suffix:” €”, groupingsymbol:”.”, decimalsymbol:”,”, currency:true}))
Works fine. Now when I add another calculated field, it is possible to “read” if its % or €? I tried the following things but it doesn’t show anything:
IF(INCLUDES(fieldname2, “€”), fieldname2,fieldname3)
function die(fieldname2) {
if (fieldname2.includes(“€”)) {
return fieldname2;
} else {
return fieldname3;
}
}
“Contains” instead of “includes” also doesn’t work … Any suggestions?
Thanks!
PS. I know I could simply repeat the if statement in the calculated field 2 but when its a more complex furmala, the reading would be just more simple 🙂