Forum Discussion
Help with a 'complicated' measure
HI, timknox
This link works, and the same point confused.
EXAMPLE FOR CONTRACT ITEM 1.1 - 20% that was withheld on 1/11/18; 10% was paid on 1/12/18 and 10% was paid on 1/1/19
EXAMPLE FOR CONTRACT ITEM 1.1 - 30% that was withheld on 1/12/18; 30% was paid on 1/1/19
EXAMPLE FOR CONTRACT ITEM 1.2 - 20% that was withheld on 1/10/18; 20% was paid on 1/12/18
For example
Do you mean it is based on the Percentage Cost Withold (Paid) table,
But why 1.3 has no data, and for 1.1 TOTAL Paid in 1/1/2019 is should 222+23.3+136.8-0=382.1
and 1.2 TOTAL Paid in 1/1/2019 is should 273.95, why it needs to add 136.80?
Best Regards,
Lin
But why 1.3 has no data, >>>>> i just did not do the example :-)
and for 1.1 TOTAL Paid in 1/1/2019 is should 222+23.3+136.8-0=382.1 >>>>>> Correct - sorry
and 1.2 TOTAL Paid in 1/1/2019 is should 273.95, why it needs to add 136.80? >>>>>> Correct - sorry
i have updated the file [Output Required]
https://www.dropbox.com/s/8rizb42cqku62mh/OutPut%20Required.xlsx?dl=0
I have updated the tblFOO file, as there will be more than one item under a contract item.....
For example, Contract Item 1.1 has the following different items under it:
Deliver box Deliver box scews Deliver square box Deliver small box The link for the revised file is here: