# How to calculate overall V2G score from BigQuery file (variant\_gene)

**URL:** <https://community.opentargets.org/t/how-to-calculate-overall-v2g-score-from-bigquery-file-variant-gene/1230>\
**Category:** Google BigQuery/Cloud\
**Tags:** bigquery, data, data-updates\
**Created:** [10 October 2023 11:24 UTC](https://community.opentargets.org/t/how-to-calculate-overall-v2g-score-from-bigquery-file-variant-gene/1230 "2023-10-10T11:24:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dimitris\_Zisis](https://dub1.discourse-cdn.com/flex017/user_avatar/community.opentargets.org/dimitris_zisis/32/399_2.png) [@Dimitris\_Zisis](https://community.opentargets.org/u/Dimitris_Zisis)\
**Post date:** [10 October 2023 11:24 UTC](https://community.opentargets.org/t/how-to-calculate-overall-v2g-score-from-bigquery-file-variant-gene/1230/1 "2023-10-10T11:24:54Z")

</div>

Hi,  
I was wondering why the column **overall v2g** is missing from the variant\_gene file from BigQuery open targets genetics repository and how is it possible to calculate it ?  
I am using a query to intersect the v2g results for my GWAS datasets and i need to include also the column for the overall v2g score.

Can you give me an example of the formula for a variant? How the overall v2g score would be calculated manually from the columns available in variant\_gene file from BigQuery ?