Really hard to tell like this, it could have been better if you had provided the mock-up data
I tried to re-create your error
And, if it is similar to above then you can remove 'attr' there , it looks like a string value.
Please mark the answer as CORRECT and HELPFUL if it has really helped you.
Thanks for looking into it. You have used the Ship Mode dimension which is from the same data source so the error gone but i am facing the issue because Airline dimension on which i am performing the if check is from different data source.
Please use any field which does not belongs to same data source then you will be able to create the exact scenario on which i am not getting any clue to get rid off from it.
Please use Data blending between this two database and then create calculations. if it works then please do reply me correct or helpful.
Amar D. Saavale
Thanks a lot for taking a time to check my issue Ritesh. The calculation window is not giving any error after using attr function with the case statement however I am not getting the expected results. Please see the attached screen shot. I have all the valid values in Airline dimension which i am checking in the if condition but the calculation is going into else condition for both when conditions. Please see the result on back sheet of calculation window it is showing only 'UA' and 'ZX'.
I think i am missing something from my end but could not getting what it is.. thank you,