I have written a calculation such that if a dimension has those values and a date function it needs to display a measure value.
IF(ATTR([Sun_Penders (DSM)].[Stat Cd])= "PS" AND "UW")
AND IF (DATEDIFF('month',[Tran Dt],TODAY()) <=13) THEN SUM([Anp Lc])
It throws an error - expected 'then' to match 'if' at character 0
Can anyone please let me know the reason??
Appreciate any help !! Thanks!!
Try deleting IF.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...