SAP FC 10.1 Date difference functions to use in a report

[former_member40190]

Hi ,

My question is regarding SAP Financial Consolidation 10.1 Report.

Can anyone please help me with date functions to use in a schedule cell ? I am trying to build a report where I need calculate the difference between two dates and I am not aware of any functions that can help me do that . Does FC report have date difference function/feature ?

Regards

Aditya

[adelaide_brunel]

Hi Aditya,

Can you please illustrate with screenshots how is built your report and what you want to do exactly ?
It will be easier to confirm it is feasible or not.
Thanks
Adélaïde

[former_member219022]

Hello Aditya,

You can use IF in the formula to compare the two cells.

Here is what is described in the FC user guide:

A manual formula is made up of data IDs (which define the dimension values of the data in the formula) which are linked by operators (such as: +,-,*,/) or functions (such as: IF, ABS).
Check out the guide below:

https://help.sap.com/docs/SAP_BUSINESSOBJECTS_FINANCIAL_CONSOLIDATION/b9d07a1932014658b7ac8268c5c2b4...

Regards,
Yang Yang