Need an "if" expression

[elstanford0430]

I am trying to write an expression based on the selection of another expression.

My report allows the end users to select actual revenue or expected revenue on a financial report.  I need the resulting Net Income calculation to populate correctly based on the revenue field that is selected.  Is this possible?  If the user has to select the correct Net Income to match the revenue field they selected, that may be messy if they do not do that correctly.

Thanks in advance.

ELS

[chrismarlow]

Hi,

What are you using to select the field? Are your different Net Income calculations different columns in your data or different sets of rows?

Cheers,

Chris.

[elstanford0430]

1 row for each patient.  The charges (revenue) field contains a cyclic option to allow the user to select actual or expected.  I can only create a net income based on one or the other unless I can link it to their selection.  Does this help?

[chrismarlow]

Hi,

I think you should be able to use If(GetCurrentField([Your Group Name])='xxx', …) to toggle, something like the screenshots below.

Cheers,

Chris.

[elstanford0430]

thank you but will this work if I have only one field with the actual and expected charges and one field with actual and expected net income (using a cyclic group for both)?

How would I write the formulas or would I use your information below and create two formulas for NI? I am new at this.

[chrismarlow]

Hi,

Can you share the 4 formulae - i.e. actual and expected for charges and income? I am struggling to visualise what your data looks like … assume something about the rows included for a field gives actual & expected ...

Cheers,

Chris.

[elstanford0430]

I provided an attachment that may better show the issue.

[elstanford0430]

Gross Charges = sum([Actual Charges])

Adj Gross Charges = sum([Actual Charges])-sum([Non-Covered Charges])

[chrismarlow]

Hi,

With a large nod to Cyclic-expression-GetCurrentField I think the following will work for you;

[Net Income]/if(len([Gross Charges]),[Gross Charges],[Adj Gross Charges])

Ignore the bad field name error, it seems to work itself out. Other option I think is to use Column() - but above I think is easier to follow.

Cheers,

Chris.

[elstanford0430 · Accepted solution]

Thank you!  I had to adjust the formula for the full Adj Charges field name and it is working!