KNOWLEDGE BASE

Error: 'No Such Column...' when Utilizing IIF() Calculation with LOD Expressions


Published: 27 Sep 2018
Last Modified Date: 26 Feb 2019

Issue

When changing a parameter value based on a calculation that uses nested IIF() functions and LOD Expressions, the following error occurred: 
No such Column..

Example calculation:
 
IIF([Year Type] = 'Calendar', [Sales Year],
    IIF([Year Type] = 'State Fiscal', IIF([Sales Year] = {FIXED [State] : MIN([Sales Year])} AND MONTH([Sales Date]) < [State Fiscal Year Start Month], NULL, [State Fiscal Year]),
        IIF([Year Type] = 'Standard Fiscal', IIF([Sales Year] = {FIXED [State] : MIN([Sales Year])} AND MONTH([Sales Date]) < 7, NULL, [Standard Fiscal Year]), NULL)))

Environment

Tableau Desktop 2018.1.9, 2018.2.6, 2018.3.3 and earlier versions

Cause

This behavior is related to a known issue with ID 817189, which has been corrected in more recent versions.
Did this article resolve the issue?