Calculate current month in cloud for customer

[Former Member]

Dear experts,

I have the following question. I need to calculate a new key-figure in a Cloud for Customer Rerport like this:

("KF1" /12 * current month)

but I don't know how to get the current month in that case... I know, that there is a DATE() function but I don`t think that this will help me in my calculation... I just need the number of the month. E.g. if its April then the calculation should look like this:

("KF1" /12 * 4)

Do you have any suggestions?

Greetings,

Paul

[Former Member · Accepted solution]

Okay we got the solution. We had to create another data source, so that we could import the "current month" key figure trough a HCI Web-Service.

[Former Member]

Hello Djalma,

the Data Source I am using is "Account Master Data" (CODCUSTOMER). The key figure is a customer specific development, but nothing special just a simple counter. My problem is, as I said the "current month". Thank you for your time and effort!

regards,

Paul

[djalma_lucassubtildissenh]

Hello Paul,

I will try to create this KF, but i need to know what the KeyFigure you use on the "KF1" and what DataSource?

BR,

Djalma Dissenha