Forum Discussion

timknox's avatar
timknox
Icon for Helper II rankHelper II
7 years ago

Help with a 'complicated' measure

hi,   I am trying to write a measure, but i am stuck!!   Basically i have a data set - below is an example: Item Value Date Cost Withheld Paid 1.1         234.00 01/09/2018 0%     ...
Need Help
timknox's avatar
timknox
Icon for Helper II rankHelper II
7 years ago

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

  • timknox's avatar
    timknox
    Icon for Helper II rankHelper II
    7 years ago

    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:

     

    https://www.dropbox.com/s/0x2h7rhxh8ehs5t/tblFOO.xlsx?dl=0