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

 

Relationship.png

 

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

Attachments

Outcomes