CASE WHEN Formula Not Displaying Correctly
Summary: CASE WHEN STATEMENT shows two different results pending the format export
Content (required): I'm using the following CASE WHEN statement to label a value either "To" or "From
WHEN "Transaction Distribution Lines"."Reserve" >= 0 THEN 'To'
WHEN "Transaction Distribution Lines"."Reserve" <= 0 THEN 'From'
When I export the analysis as XLSX
it shows all values as 'To' but if I export the analysis as CSV then it displays the correct output.
Does anyone know why this would be?
Version (include the version you are using, if applicable):23A
Code Snippet (add any code snippets that support your topic, if applicable):