3 Replies Latest reply on Nov 6, 2014 12:46 PM by Grayson Deal

    Help needed with a calculated field

    Liliya Fisher

      Hello,

      My data source combines data from 2 sources and resides on Tableau server. The first source is original raw data and has fields: modified Sector, modified BG and modified BIU and second source has fields sector_corrected, business_corrected and business_innovation_unit corrected. I need to create a formula that says: If modified Sector is null, give value in sector_corrected field, if modified BG is null, give value from business_corrected and if modified BIU is null, give me value in business_innovation_unit. I also included a screnshot of my data and fields. Could someone please help me with a formula?