Hi all,
Is it possible to use Sets in an 'if -then ' calculated fields.
eg. if a=b then 'Set_1'
else 'Set_2'
end
it gives me a boolean error if i create a calculated field like this.
Kindly help me with the same
Regards,
Sanket
Hi Sanket,
Instead of creating parameters you can show the values directly using filters will this solution work for you?
you can use sets and create calculation as below
CASE [Trend selection]
when "Yearly" then [Fy year]
when "T" then if [T_Set] THEN [Year] end
when "T-1" then if [T-1_Set] then [Year] end
END
However when you place this cal in rows or column shelf you see null values which you need to hide
You cannot show the data "Monthly" and "Quarterly" as you have only year data which is in string format
please find the attached workbook for your reference
Thanks,
Sreekanth
