Jump to content
We've recently updated our Privacy Statement, available here. ×

Value another Column - Cross Table


Felix Zuniga

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...