AnsweredAssumed Answered

Help with Relationship

Question asked by thong127 on Sep 5, 2017
Latest reply on Sep 5, 2017 by philmodjunk

Hello All,


I have a problem with my relationship. In my Dashboard I have an alert that will tell me how many materials are expiring & to be retested but my problem is it showing me a  "?"


The relationship graph is below




Dashboard Fields

Constant = 1

Constant Today = Get (CurrentDate)

Global Number = Number field Value is 1


Material_Expiring Today

Constant = 1

Material Expiry Date = Date Field

Material Stock = Calculation (Material Quantity Received - Sum ( Material Transactions::Quantity Dispensed )


If I change my Material Stock into a Number Field It will show my desired output.


Please see attached file that Im working.


Any help is highly appreciated.


Thank you