Skip to main content
Topics#Reports & DashboardsRochelle Montney 的问题
Rochelle Montney 提问于 #Reports & Dashboards
2014年11月6日 16:01

In reports, can you create a rule to pull in a field only if another field is populated?

I've created a Matrix Format Report with the field "Stage" as the Column Grouping.  We have a stage where it's basically 2 different stages.  There is a Stage 6 awarded and then Stage 6 awarded and approved.  At the Stage 6 awarded and approved there is another field that is populated by our credit department. 

 

In my report I want to state, include Stage 6 ONLY if the credit analyst has populated a date in the related field.

 

Hope this makes sense.

 

Thanks in advance!
6 个回答
  1. Sunil Sarilla (M&G Investments)
    2014年11月6日 16:40
    Hi Rochelle,

     

    In my previous answer the filter logic should be 1 OR (2 AND 3)

     

    Stage equals stage1, stage 2, stage 3, stage 4, stage 5

     

    Stage equals stage 6 awarded, stage 6 awarded and approved

     

    date related field not equal to "Leave it Blank"

     

    Filter Logic is 1 OR ( 2 AND 3)

     

     
撰写回答...
0/9000