Forum Discussion

Matt_Mohawk's avatar
Matt_Mohawk
Icon for Helper II rankHelper II
5 years ago
Solved

Needing Help with Date Out Not Showing Certain Criteria

Hello,   I am trying to get my report to show our Voids that we have in our project list. I am currently filtering out everything using my Date Out field but the voids do not have a date entered fo...
Need Help
  • Matt_Mohawk's avatar
    Matt_Mohawk
    5 years ago

    I was able to figure it out. Thank you for the help that both of you have given.

Matt_Mohawk's avatar
Matt_Mohawk
Icon for Helper II rankHelper II
5 years ago

Yes the dates that are shown are by month. The first image that was in the attachment shows that on 5/7/21 there was a void. It isn't showing up though for the month of May on the chart.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Matt_Mohawk ,

    It seems that the field [JOB LIST] is a calculated column, could you please check whether it can return the value "VOIDED"  in table MJS_PRICE_PW when it fulfill the listed conditions(AND(ISBLANK(MJS_PRICE_PW[DATE OUT]),MJS_PRICE_PW[J6STAT]="V"))? Besides that, please check if there is any sync slicer or report-level filter to apply in the report pages to affect the column chart result....

    Best Regards

    • Matt_Mohawk's avatar
      Matt_Mohawk
      Icon for Helper II rankHelper II
      5 years ago

      I was able to figure it out. Thank you for the help that both of you have given.