Calculated field does not show all columns of referenced table

(0) Share

Report

Posted on by StmPp

Hi,

I would like to create a calculated field in the table "HighValueCustomer".

This field should calculate the difference between two date fields in the table "ai_op_debitor". So something like Diffindays(ai_op_debitor.d_zahlung,ai_op_debitor.d_rechnung)

My question is, why neither d_zahlung nor d_rechnung are proposed in the calculated field?

My calculated field is datatype whole number (I also tried to set that field to datetime or text)

The field d_zahlung and d_rechnung are both datetime

TX in advance!

Categories:

Entities

All responses (1)

Answers (1)

Verified answer

H Sheild 3,000 Most Valuable Professional on at

Like (1)

Report

Re: Calculated field does not show all columns of referenced table

Hi @StmPp ,

I have done something similar before in my system and it works fine.

Looking at your screenshots, d_zahlung on ai_op_debitor looks to be a multiline text field. Is this correct? You said that it was a date time field.

If I was you I would double check everything and also make sure that you Publish All Customisations.

Hope this helps