I have list of product batches that have a Batch Creation and Batch Expiry Date as a Date column types.
I have created two virtual columns respectively:
I thought I could use the following expressions based on what I saw in other posts:
I tried using both Number and Decimal column type for the virtual columns but I recieved the following error respectively
The expression is valid but its result type โDurationโ is not one of the expected types: Decimal
I get the same for Number column type.
What am I missing here?
Solved! Go to Solution.
The result for this [Batch Expiry] - [Batch Creation] is a duration like hours:minutes:seconds. If you want to have it as days, you should write it like TOTALHOURS([Batch Expiry] - [Batch Creation])/24
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |