Here is a good one.
So when using an if statement with all variables in the group by column - no issue.
But if I try using that same IFELSE statement using both the “group by” and the “values” column that contains a custom calculation, I get a syntax error (quicksight is not very good at explaining error messages, by the way).
For example, here is a simple (apparently not) table with 3 columns. I simply would like to create a new column named:
“Unmatched”
which simply checks to see if the “Mismatch” column is false AND if the UPH is greater than zero (or not null, whichever works).
Essentially, if there no mismatch AND there is a UPH, simply display “yes” or “no”
Hi @David_Ako-Bryant,
It’s been awhile since last communication on this thread, are you still encountering the same issue or were you able to find a work around? If still dealing with this; could you please share the calculated fields (mismatch and UPH) as well as the calculated field that you’re trying to create but is giving you an error? Once we see those, it should be easier to help diagnose where the issue is arising.
If we do not hear back within the next 3 business days, I’ll close out this topic.
I abandoned it and had to use a workaround by using the variables within the calculated fields (and not the calculated fields themselves) in the formula to get the desired result.
Thanks
