Adding Columns that Contain Text Input

[kpontarollo]

Hi!

Please see below for reference. The Field "Actual Provider Count" is something that I uploaded using the text input field. Now, I need to add the last field 1,123 + the total column for all the null fields. So, 278... 557... 837.. 1,123 are all inputted by me and starting at the first NULL row, I need to do 1,123+ Total. The second null row will have to be the result of 1,123 + Total + Total Column again and so on and so forth. 

Anyone know how to do this?

[ShankerV]

Hi @kpontarollo 

One way of doing this.

Input was:

Note: I could not replicate the whole table shared as it was like a screenshot.

Hence replicated the last row which is more important for input.

Let me know if you have more questions.

Many thanks

Shanker V

[kpontarollo]

Hi Shanker, 

I think this gets me about half way there! The running total part is messing it up I think. I need it to add the values from the "total" column (the number that is repetitively 278). So I would need the last number (1,123) to add the number adjacent in the total column (which happens to be 278 for every row, but that could change depending on query). So then 1,123 + 278 and then that would give me row 5, the result of row 5 + 278 would give me row 6 and so on and so forth.

Is there a way to adjust this query to do that?

Thanks for your help!

[ShankerV]

Hi @kpontarollo 

Sure there are lot of ways to adjust. Might be I couldnt understand completely from your requirement,.

Can you share what is the output expected, so that I can easily understand it.

Thanks in advance.

[kpontarollo]

Of course! I appreciate the help!

See screen shot below: I am looking to fill in the Null values below (circled in pink) so starting with 1,123 (which was a text input) I need to add 278 (circled in purple) to replace the first Null (which should equal 1,401). Then take 1,401 and add the total column again (which just happens to be a repeating 278) and so on and so forth. Does that clarify?

[ShankerV]

Hi @kpontarollo 

As per the latest requirement, please find the output below.

Let me know if you have more questions.

Many thanks

Shanker V