Forum Discussion

juliausha's avatar
juliausha
Icon for Helper I rankHelper I
7 years ago
Solved

Running total for a row avoiding NULL values

Does anyone know how to calculate running total for a row making sure null values are avoided?    My example:    Each row represents amount of shops someone has in the neighbourhood, and co...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, juliausha 

    Please drag "VisitedShops" field from VisitedShops table into Columns Value.

     

    Best Regards,

    Lin

     

     

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, juliausha 

Please drag "VisitedShops" field from VisitedShops table into Columns Value.

 

Best Regards,

Lin

 

 

 

juliausha's avatar
juliausha
Icon for Helper I rankHelper I
7 years ago

Ah, great, it works now! Thanks so much v-lili6-msft !