Value another Column - Cross Table

[Felix Zuniga]

Hi Experts! I need that when the day is distinct of first day, the value in "Initial Charge" will be the value of "Final Charge" of day before. I tried to "OVER" function but it wasn't worth it... Anyone help me, please

[Richard Pobi]

Your message is not clear! Try this, You should create a calculated column. Sum ([Final Charge]) OVER Intersect ([initial Charge], ALLPrevious([Date]))

[Felix Zuniga]

Hi Richierich, I will try to explain it better.

 

 

 

[[{"fid":"154896","view_mode":"default","fields":{"format":"default","field_file_image_alt_text[und][0][value]":false,"field_file_image_title_text[und][0][value]":false},"type":"media","field_deltas":{"1":{"format":"default","field_file_image_alt_text[und][0][value]":false,"field_file_image_title_text[und][0][value]":false}},"attributes":{"class":"media-element file-default","data-delta":"1"}}]]

 

- The field "initial Charge" comes from a File and I can't have a left join with Original table because I will have a duplicity of values. The File only has a value for day 1

 

- The field "final Charge" is the sum of "initial Charge" minus Download 1, 2 and 3. The Downloads comes from Original table.

 

- The column "initial Charge" for a day distinct of one must be "final charge" value of day before. If day = 3 "initial Charge" THEN "Final Charge" of day 2

 

I hope I have made it clearer,

 

Thank you very much!!

 

Flix Ziga