5 Replies Latest reply on Aug 14, 2018 10:21 AM by suman kumar

    Validation Check in Tableau

    Chike Ckuks

      Hello, please if anyone can help with attaining this view would be much appreciated. Please, find my workbook attached. I am trying to attain the column highlighted green which is the same formula as the column right to it. Thanks very much.

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      CurrencyCashCNFTRDTTMOENFPDAQAOSMTAMMBMMTMMATotalValidation:
      France            -            4.4            -              -              -            -            -            -                  -            -                  -                 -                 -                  -                 -          4.4 TRUE
      Germany            -         92.7            -              -              -            -          0.0          -                  -          0.0                -                 -                 -                  -                 -       92.7 TRUE
      UK     100.4      (61.0)           -       175.2       18.9   194.1   101.1       3.0                -     104.1           40.0             6.2               -              (2.2)            4.0   381.5 FALSE
      RUSSIA          9.8            -              -              -              -            -            -            -                  -            -                  -                 -                 -                  -                 -          9.8 TRUE
      NORWAY            -            0.4            -              -              -            -            -            -                  -            -                  -                 -                 -                  -                 -          0.4 TRUE
      AUSTRIA            -            0.0            -              -              -            -            -            -                  -            -                  -                 -                 -                  -                 -          0.0 TRUE
      Australia          5.1          0.3            -              -              -            -       11.1          -                  -       15.1             0.0             4.4               -                  -               4.4     20.9 TRUE
      ESTONIA            -              -           0.1            -              -          0.1        1.4          -                  -          6.4           14.3               -                 -                  -                 -       25.9 TRUE