Calculated Key Figure Issue

25 Views

Hi Gurus,

I defined Calculated key figure as show below

*NODIM ( ( NetSales * Number of Days) / Total Number of Days)*

Numbers of Days - Formula Variable ( Customer Exit, Singel Value, Mandatory, Under Currency Type Dimension is Number)

Total No of Days - Formual Variable ( Customer Exit, Singel Value, Mandatory, Under Currency Type Dimension is Number)

But it is not allowing to save the formula as above and it is save as shown below

*NODIM ( ( NetSales * Number of Days / Total Number of Days) )* - Difference is closing bracket before '/ ' is moving to the end i.e before last close bracket.

This CKF been used to get the actual vs plan. I am getting warning that query definition is wrong.

Please clarify me is that my formula variable is defined correctly or some thing wrong in CKF.

Please help me to fix the issue.

Thanks

Ganesh Reddy.