cancel
Showing results for 
Search instead for 
Did you mean: 

formula

Former Member
0 Kudos

Hi,

I like to show difference of 2 dates, one is variable whose value is selected by user (0calday), and another date is a characterstics.

The output which i am looking for is:

some fields for disaply with the difference of dates

please give me suggestion what approach i will follow?

Cheers!!!!

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi,

You can create 2 forumla variables (replacement path) based on 0CALDAY and the other char and then use them in a formula.

Hope this helps...

Former Member
0 Kudos

Hi Bhanu,

While creating Variable for 0calday, i am getting the option as characterstics variable only, not able to do any modifcation, do you have idea why?

Cheers!!!!

former_member188325
Active Contributor
0 Kudos

Hi,

where r u creating variable for 0CALDAY? u should create formual variable from 'formula'.

i.e. new formuala-->rght click on formula variables->new fomula variable.

hope this helps

Former Member
0 Kudos

I am getting error while saving,

<b>VAR2 can't be replaced</b>

Below are the steps which i am following:

1) Create a formula variable with

processing as 'Replacement path'

Name= VAR1

Characterstic = '0CALDAY'

Replacement variable with = 'Key'

Dimesion id = 'date'

2) Create a formula variable with

processing as 'Replacement path'

Name= VAR2

Caharacterstic = 'some date chr'

Replacement variable with = 'Key'

Dimesion id = 'date'

Why the error?

Cheers!!!!!!!

former_member188975
Active Contributor
0 Kudos

Hi,

Can you give some details about your "some date chr"...

Former Member
0 Kudos

0CREATEDON

former_member188325
Active Contributor
0 Kudos

0CREATEDON is defined as KF or Char?

former_member188975
Active Contributor
0 Kudos

Hi,

Have you included 0CREATEDON in your query definition?

Former Member
0 Kudos

Hi Bhanu,

Now i have defined the 0CREATEDON as free characterstics, and no error.

But since i don't need any KF in my query, and like to have difference of dates as only KF, but its giving error that no KF, do i have to assign these value to some KF? and if yes then how?

former_member188325
Active Contributor
0 Kudos

try to put 0CREATEDON in rows or columns anf try to create formula variable.

regards

former_member188975
Active Contributor
0 Kudos

Hi,

First lets try to get it working, so add any KF and Hide it if you don't want to see it...

former_member188325
Active Contributor
0 Kudos

put any kf in columns and try,u can hide this kf if u dont need.

regards

Former Member
0 Kudos

Hey Bhanu/CC,

Finally running the report i m getting value as Cross Sign only?

y

former_member188975
Active Contributor
0 Kudos

What did you put in the forumla you created?

former_member188325
Active Contributor
0 Kudos

are you able to see values for u r two formula variables?to check that...display them (two more columns using new formua) in Query for time being.

regards

Former Member
0 Kudos

Hi Bhanu,

I am getting 0createdon as values from infocube, but that 0calday i want to take input from user, do i have to create one variable for 0calday, as i m not getting anyvalue of 0calday i think?

is it?

Former Member
0 Kudos

Hey CC,

i have created to new formula variables, but for both i am getting X as value?

former_member188975
Active Contributor
0 Kudos

If you need input from the user, you can do the forumla variable with User Entry instead of Replacment path.

former_member188325
Active Contributor
0 Kudos

hi pl check whether u r getting values for u r two formula variables and lets know....i thnk u have to create a variable on 0CALDAY or restrict with some sap exit variable (like...current date...)....thyen see..

lets wait for bhanu's response...

regards

former_member188325
Active Contributor
0 Kudos

Hi BI,

do u have 0CALDAY in rows or columns?if not,add it and see the result.

regards

Answers (1)

Answers (1)

former_member188325
Active Contributor
0 Kudos

Hi,

pl refer following links which may help u.

regards