Calculation of values depending on the report date in C4C Analytics

[uwekiel]

Ich habe folgendes Problem, zudem ich keine Lösung finde. Ich möchte in einem Report Daten berechnen, die ich nicht im BusinessObject abgelegt habe. Sie sollen sich auf das Tagesdatum (Today) beziehen. Eigentlich möchte ich zum Tagesdatum nur das Jahr abprüfen und abhängig davon die Werte berechnen. Ich finde keinen Ansatz, wie ich das mit den Key Figures hinbekomme.

Ich habe einen Wert X und möchte ab hängig vom Tagesdatum den Rest Jahres Wert berechnen, aber nur dann, wenn der Wert aus dem gleichen Jahr ist. Ansonsten soll er zu Null gesetzt werden.

I have the following problem and I cannot find a solution. I want to calculate data in a report that I have not stored in the BusinessObject. They should refer to the current date (Today). Actually, I only want to check the year for the current date and calculate the values depending on it. I can't find a way to do this with the key figures.

I have a value X and want to calculate the rest of the year depending on the current date, but only if the value is from the same year. Otherwise it should be set to zero.

[mjveerhuis1]

Hi Uwe,

Can you indicate which process and object you are talking about? And maybe provide a real example (little excel table) with the values you are looking for? Are you looking for some so called [year to date] value? If you want only the year of the current year - please also check the relative selection criteria. My first thought is that you will have to define additional calculated key-figure(s), but if you have more details I can provide some more direction.

Kr.

MJ

[uwekiel]

Hi Marie José,

We have a special total negotiated value, which takes into account an annual production quantity. We also have a different financial year. Our financial year starts on 1.12. and ends on 30.11.

The aim is to calculate the rest value for the quantity and the monetary value in the report. However, this should only be shown if the opportunity from the close date in the current calendar year or in the next year still brings a value. I thought about doing these calculations via SDK, but this would mean that I would have written the values to a table and would have to recalculate them for the corresponding opportunities when the year changes in order to adjust the values. I would like to avoid this.

Opprotunit 1 has a close dater 31.5.2021 with a value of 500 000 EUR and a quantity of 100000. Then I still have 183 days for the rest of the year. This results in 500 000 EUR /365*183 = year remaining value. The same applies to the quantity to be produced. That is the basic principle.

My problem is quite simple I have to determine the year from the value of TODAY (Reporting Date) and compare it with the year of the Close Date. There SAP offers me this value Year CloseDate.

So if I look at the opportunity list in the same year from the opportunity close date, then the remaining year value (as calculated above) must show up in the next column, the remaining year value for the following year should be given.

If I then look at the opportunity list in the next year, the first part of the opportunity has been processed and I then have the value

My problem is to get the year of the day the report is started. If I can get it, I want to calculate the end date of the financial year and the end date of the following year.

I hope to use similar formulaic rules as in Excel. At the moment I have little experience with calculating key figures in reports.

Best Regards Uwe