11 Replies Latest reply on Feb 1, 2019 11:34 AM by Gianni Ceresa

    RPD -- BM and Mapping:- Data not displaying on Analysis

    Rai Qaiser Hussain

      Hi All

      In Business Model and Mapping there are two fact logical tables and many dimensional, as you can see in below Figure, I have written below statement in field of F2 Lab Revenue which is also highlighted.

       

      I have a requirement to show LAB revenue separately, Total Cash Amount contains cash of every department, after adding case system should return cash of LAB only but it returns the zero amount --- data at db exists

       

       

      CASE

      WHEN  "Revenue"."D04 Department"."Department Id" ='0010100' THEN

      "Revenue"."F1 Revenue"."Total Cash Amount"

      ELSE

      0

      END

       

       

      BD- Field Referred from another table.jpg