Difference between two calculated columns

Duncan Greenaway shared this question 2 years ago
Answered

In my report I have two columns: EV this month and EV next month what i want to do is add another column which will return the difference between these two columns.

My issue is that both these columns results are returned from advanced functions and therefore I cannot see a way of adding a further advanced function to get the difference.

Please help

Comments (4)

photo
1

Hi Duncan,

what you can do in that situation is to use the feature called "Use as View" which you can find in the Report Settings tab of the Save Report dialogue.

In other words, when you save your current report as a view, then you can make a new report based on that view, and those 2 columns that were created by using an Advanced Function will just appears as regular columns, so you'll be able to apply a new Advanced Function to them.

I hope that helps you meet your reporting requirements, if not, then please let us know.

regards,

David

photo
1

Hi David

Thank you for that, that looks like it should work however I have other issues with the report not returning values so I’ll get that sorted and then try your solution.

Thank you

Duncan Greenaway | Group Management Accountant

Scott Brownrigg | St. Catherine's Court, 46-48 Portsmouth Road, Guildford, Surrey GU2 4DU

T:  +44 (0)1483 568 686

1cf9107b99fafe76292e94d1c7719b9f 

London | New York | Singapore | Hong Kong | Moscow | Cardiff | Edinburgh | Guildford

www.scottbrownrigg.com

 

Click here to download the Scott Brownrigg App for free from the App Store.

From: Yellowfin Support [mailto:support@yellowfin.bi]

Sent: 27 November 2017 04:24

To: Duncan Greenaway

Subject: New Comment in "Difference between two calculated columns"

photo
1

Big Dave

Thank you sorted out my report and it works brilliantly.

Ta

Duncan Greenaway | Group Management Accountant

Scott Brownrigg | St. Catherine's Court, 46-48 Portsmouth Road, Guildford, Surrey GU2 4DU

T:  +44 (0)1483 568 686

8987a0b5fe47f6c29f4fb440661e9afc 

London | New York | Singapore | Hong Kong | Moscow | Cardiff | Edinburgh | Guildford

www.scottbrownrigg.com

 

Click here to download the Scott Brownrigg App for free from the App Store.

From: Yellowfin Support [mailto:support@yellowfin.bi]

Sent: 27 November 2017 04:24

To: Duncan Greenaway

Subject: New Comment in "Difference between two calculated columns"

photo
1

that's great new Duncan! Thanks for letting us know.

regards,

David