I peeked into your data and it seems like missing data may be resulting in the issue. PO Line Status is used as baseline for calculated fields, which is not always populated.
Can you pinpoint an example record that you would like to surface in the dashboard depending on the selected parameters? It can be traced back to data. I can then reverse engineer what might be going wrong.
Thanks for taking a look at the problem. Below is the example of one of the PO #.
PO # (column M) - 1000001034 is associated with Req # 1726 (Column B) with amount (Column H) - 3900000. I am able to get the Req # in Column B but not the amount associated with it in my Dashboard.
Same PO is linked with Invoice # (Column T) 6001714 with amount (Column Y) - 1000981.47. I am not able to get the information that invoice # and its amount in the dashboard.
Thanks for the help. Let me know if you have any question.
Your logic for calculated field Open/Closed Po is as follows:
IF [PO Line Status] = "Cancelled" THEN "Closed PO"
ELSEIF [PO Line Status]!= "Closed" THEN "Open PO"
ELSE "Closed PO"
However, when I reviewed the data in excel file, PO Line Status takes following unique values:
created, partially_received, received
So invariably, you are always assigning "Closed PO" to all records as your calculated feld Open/Closed Po hence the Invoice # does not show up.
Try changing the logic to following:
IF TRIM([PO Line Status]) = "Cancelled" THEN "Closed PO"
ELSEIF TRIM([PO Line Status]) = "partially_received" OR TRIM([PO Line Status]) = "created" OR TRIM([PO Line Status]) = "received" THEN "Open PO"
//ELSEIF [PO Line Status]!= "Closed" THEN "Open PO"
ELSE "Closed PO"
Also if you closely look at the data, the invoice# is null most of the times:
These are the only records that are retrieved for Open PO.
Hope that clarifies some air. Let me know if you have more questions.