Forum Discussion
Update a query table
My comments are late. So it seems to me that this is 3 step. 1st step is make a new calculated column that adds the conversion value itself as another new column to your transaction table. This is easily done by joining the 2 tables by the date field - and then using the calculated column feature.
This will result in nulls in this new field for rows that have a date that do not join.
The 2nd step then is to use the Fill Down feature which will apply the Conversion value just above to the rows below.
The 3rd step then is to do another new calculated column that is the math of the amount * conversion value = conversion amount
My comments are late. So it seems to me that this is 3 step. 1st step is make a new calculated column that adds the conversion value itself as another new column to your transaction table. This is easily done by joining the 2 tables by the date field - and then using the calculated column feature.
This will result in nulls in this new field for rows that have a date that do not join.
The 2nd step then is to use the Fill Down feature which will apply the Conversion value just above to the rows below.
The 3rd step then is to do another new calculated column that is the math of the amount * conversion value = conversion amount
This worked very well!
Thank you!