Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I declared in the script a date field with inputfied.
I use this field in a linear table [inputsum (DataConsAgg)], to calculate other dates (Prep New, SL New, ..... MIG New)
it happens to me that, updating this date on a line, sometimes, the dates of the other rows are altered while I want the dates of each row to depend only on the date entered in the input field of that row. I can not understand when it happens and why.
maybe I do not use the function correctly or do I have to act in another way?
can you help me please ?
Data Consegna Richiesta | Articolo | Data Cons al Cliente | Prep New | SL New | Fasc New | Ass New | MIG New |
---|---|---|---|---|---|---|---|
03gen18 | CM45-3373 | 03/01/18 | 28nov | 30nov | 04 dic | 06dic | 12dic |
26gen18 | CM35-3344 | 26/01/18 | 04gen | 05gen | 08 gen | 09gen | 11gen |
02lug18 | CM35-3396 | 02/07/18 | 11giu | 12giu | 13 giu | 14giu | 18giu |
02lug18 | CM35-3397 | 02/07/18 | 11giu | 12giu | 13 giu | 14giu | 18giu |
16lug18 | CM35-3395 | 16/07/18 | 25giu | 26giu | 27 giu | 28giu | 02lug |
Another question.
can one use a calculated expression in another chart? If yes, how do you do it?
It is easier to help you if you provide a sample application to us...
Hi,
Make sure you create enough records for this input field, e.g. one for each potential row of your table.
A sample app, or your script could help.
Regards,
Thomas
The app is attached here
Hello.
I try to better specify my request for clarification.
in a pivot table I put an input field ("Data Cons to the Customer"). This expression field (inputsum (DataCondAgg) contains a date, and the dates on the right are adjusted for this date (Prep New, SL New, etc.).
The app works. But sometimes, and I can not understand when and how, changing a date in a row also incorrectly changes the date values on the other lines.
having no example of an Inputsum with a given field, I had the doubt that this function was not enabled for dates. I'm walking on a mistake.
could you kindly give me some help?
Thanks in advance