Hi All,
I have a dashboard which uses six different datasources.All are using amazon redshift database.Among them I choosen a datasource and tried to write a calculation.Let me call it datasource 'A' and datasource 'B'.Now I tried to write a calculation in Datasource 'A' by pulling Monthend column from datasource 'B'.The scenario is as follows:
Scenario:
I have a date column named Month end.If the month end column has data, it has to show the maximum date in text chart else it should display the current year ending date (#31-12-2018#).
Solution I tried:
For this, I wrote a calculation as follows:
IF ISNULL([Month end])) THEN ISDATE('31-12-2018')
ELSE [Month end]
END
Errors am facing:
But am getting an error when writing a calculation in amazon red shift: Expected type boolean,found date.
When I use excel sheet am getting an error like "Expected THEN to match IF"
Expected output :
31-12-2018 / Maximum date in month end column if exists
Required help:
I would be grateful if any one can explain how to handle this type of errors and expecting a possible fix to the calculation.
Have attached the .twbx file for your reference.
Thanks & Regards
sai lakshmi