Hi I have a grid where in I need to calculate the average of the commissions selected for a couple of months and then to send it to another grid of a different month. How do I do it ?PFA screenshotsNeed help urgentlyThank you
@tinathom
Yep use TIMESUM, not CUMULATE and only sum on the months you want, presumably the last three months. Use a dimensionless module to calculate the last three months so you aren't hard-coding. You've almost got this!
MOVINGSUM would be your best choice since the TARGET module also uses time. In a clutch, you can also use TIMESUM but that is not a very efficient function. If you use MOVINGSUM you'll need to also add up the denominator so you can calculate the average. This can be done by using a counter (If commission >0 then 1 else 0). This will give you the count to use to create the average.
So, MOVINGSUM(Commission of the months you're interested in) / Counter = Average commission.
Now, if you only need one value for the current month, then I would suggest you create a reporting module that is not dimensioned with time at all. This will allow you to use TIMESUM.
Thank you for replyingI used Timesum(Average) in a module that has no dimensions but it gave me a huge value.PFA screenshots @JaredDolich
Has there been any fix created for this yet?
MYiClubOnline
Hi @JaredDolich Thank you for the help and the encouragement . This helped me a lot. Appreciate it.PFA the screenshots. This looks good now right ?
Yes @Curt866 If you want , we can discuss.
Hi, Would like to ask If I want to get the average of Jan 22 and Jan 23. Is MOVINGSUM function would be the best choice to use ?
I have source module having key (combination of location and department) as a dimension and target module has employee list as dimension. i want to pull amount from source to target that should remain same for all employee having that key (key added as line item in target module). what could be the best way to handle…
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025…
I have completed level 2 certificate still I am not confident. I want practice more, where I get small project for practice.