cumulative total gives me same result as monthly total even though changed the formula
i have two formulas that give me the same result. the result i am getting is the monthly total.

this formula correctly gives me only the abc subscriptions added in the current month:

abcs started =

calculate (

[abc order count all],

userelationship(‘recurring subscriptions’[subscription start d…
hello [@scotttpa](/u/scotttpa),

for cumulative totals instead of selecting “all” replace it with “allselected” and also replace the ‘recurring subscriptions’[subscription start date]) with the dates table. so your code should be like this overall -

abcs cumulative started to date =

calculate ( [abc order count …
is thesecond account able to purchase a paid monthly subscription?no, the stores do not allow the same device account to own duplicate subscriptions.if the second account purchased a higher tier than the first account, would it all be associated with one account in revenuecat, therefore “upgrading” the first account?correct, the upgrade would be coming from the same device account so would get applied to the same app user id in revenuecat. however, the restore behavior provides you some control over what revenuecat should do:with “transfer”, the second app user id that just purchase would get the receipt moved to them, and the first app user id that purchased would lose access. this is the recommended behavior since it always gives the app user id that just purchased or restored access to the subscription - which is what most customers expect.with the “block restore” option, the upgrade would still go through, but a “receipt already in use error” would be returned to the second app user id, and the upgrade stays on the first app user id’s account. this is usually not recommendedunless you have your own support resources around to help customers with account recovery. you can use the negative lookbehind (?<!sub +) to skip matching "sub " in front of “total”.

(?<=(?<!sub +)(total amount|\btotal\b|total due|total amount due)\s+)(zar|r|)[\s-$\d,.]+

[[image]](https://aws1.discourse-cdn.com/uipath/original/3x/7/7/771d2a72ff53c33207c48813c7b379782be96d4f.png "image") Nino,

Since your subscription has been suspended (due to payment issues), you do not have to pay monthly.

In order to continue with your subscription/ resubscribe to Adobe Stock please contact our support team. Please find the link to contact support in my above post.

Regards

Twarita if you cancel your subscription, all of the data on it will be erased. you will need to contact our support team to see if they can adjust the billing date for you. since this is a community forum, we won’t be able to answer that question for you. associative law of addition:
a + (b+c) = (a+b) + c

commutative law of addition:
a + b = b + a

additive inverse:
a + (-a) = 0

zero property:
a + 0 = a

subtraction is basically the same thing as addition.
a - b = a + (-b)
instead of subtracting b, you add its additive inverse. There could be a variety of leaderboards. Like one of top points overall, and another for the most points gained in the previous 4 weeks or something. I may never top to overall leaderboard, but I have a chance of getting on a monthly leaderboard. welcome to mrexcel!

it actually works for me (see below). this appears to be a kind of rounding error. the way excel stores numbers causes some issues when you have decimals. it is a bit rare when comparing a cell to itself, but it can happen. you can try to use sumproduct instead, see column h.

efgh1valuescountifranksumproduct248737.76222336113.11333454287.76111f2:f4f2=countif($e$2:$e$4,">"&e2)+1g2:g4g2=rank.eq(e2,$e$2:$e$4)h2:h4h2=sumproduct(--(round($e$2:$e$4,2)>round(e2,2)))+1 Okay well if those query parameters really do represent arbitrary text a visitor enters into fields, then personally I would push them to separate Adobe Analytics variables instead of concatenate them, because there's no guarantee on how many characters they will be or what characters will be entered. 

I'm not sure I understand what you mean... is your site just using different query parameters for search terms, depending on the page or search widget used? So e.g. maybe you do a search and it pops k=[search term] but on search results page you do another search and it instead pops query=[new search term] ?  If so, then it sounds to me like you shouldn't concat them, but instead just look for either one and push to the variable.  

Or is it that a visitor can go to your site and search for something that results in both of those parameters showing up in the URL at the same time, with different values? 

I think I need clarification about how your site actually works vs. these two parameters. 




[View solution in original post](/t5/dynamic-tag-management-questions/internal-search-term-tracking/m-p/278167#M1141) the held amount is tied to the nodeid, not the wallet address.

but your february payout may go to the old address. I am confused, do you have 2 variables called sum? One decleared globally and one that is a parameter of a method? Maybe show the entire code or give more explanation