How to carry forward while substracting the value from current month result.

niranjan_capgemnini — Sat, 16 Nov 2024 06:52:29 GMT

Hi Expert,

I have small requirement that In my data file I have fields like below

Month,sales

Jan,10

Feb,20

Mar,30

Apr,40

May,50

Jun,60

July,70

***********************

Requirement is I have keep one input box to enter dynamic values.

Ex: current month is Jan so if user enter some value like 12 then 10(jan) value has to be replace with 12 and in next month value should be change with result like below

-->Input box [In the input box user enter like 12]

Month,sales Result

Jan,10 12

Feb,20 18 [ it will get 12(input box vlaue)-10(jan value)] =2----> 20-2 == 18

Mar,30

Apr,40

******************

up to this I achieved

but if user enter like below how carry forward into next months like mar,apr,may...

-->input box [if user enter 34]

Month,sales Result

Jan,10 34 -->it is replacing with input box value

feb,20 0 --- (34(inputbox value)-10(jan value)=24(remain value)) -->20(feb value)-24 =0 this month result and 4 is remain value

mar,30 26 -- remaing value (4)-30(Marvalue= 26)

apr,40

Kindly give some suggestion.

Thanks in advance...........

topic How to carry forward while substracting the value from current month result. in App Development

How to carry forward while substracting the value from current month result.