Formulas in charts

[Former Member]

Does any one know how to chart formulas??

[Former Member · Accepted solution]

Hi John

Do you want to apply some conditions to a chart using a formula? Please explain what exactly you are trying to achieve.

Regards

Sourashree

[Former Member]

Thank you all this forum is very hepful

[Former Member]

if {TPHASE.DF_DATE}= #1/31/2007 12:00:00AM# or

{TPHASE.DF_DATE}= #2/28/2007 12:00:00AM# or

{TPHASE.DF_DATE}= #3/31/2007 12:00:00AM# or

{TPHASE.DF_DATE}= #4/30/2007 12:00:00AM# or

{TPHASE.DF_DATE}= #5/31/2007 12:00:00AM# or

{TPHASE.DF_DATE}= #6/30/2007 12:00:00AM# or

{TPHASE.DF_DATE}= #7/31/2007 12:00:00AM# or

{TPHASE.DF_DATE}= #8/31/2007 12:00:00AM# or

{TPHASE.DF_DATE}= #9/30/2007 12:00:00AM# or

{TPHASE.DF_DATE}= #10/31/2007 12:00:00AM# or

{TPHASE.DF_DATE}= #11/30/2007 12:00:00AM# or

{TPHASE.DF_DATE}= #12/31/2007 12:00:00AM# then

{#ActiveProjDet}/1.035

else

{#ActiveProjDet}

This is what I am trying to chart

{#ActiveProjDet} is a running total.

I also need to string several if statemants together

any ideas

[Former Member]

Hi John

If you want to show the dates and the running total in the chart, you can create a formula field for the dates and use it in On change of for creating the chart.

Put the running total to the Show value(for summary).

If your requirement is different from this, please let us know.

Hope this helps!!

Regards

Sourashree

[former_member260594]

John,

You won't be able to use a formula that references a running total in a chart as it processes after the chart.

There is a workaround to charting on print time formulas and the details in are in the following white papeer/note;

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40e7130d-aa1e-2b10-ce9f-eee2a54f...