Skip to Content

Aggregation of an Formula result

Hello SAC Gurus,

I got some data that contain actual values and target values. Requirement is to give a count of records where the actual values did meet or exceed target.

Initial idea was to create a calculated figure in my model using simple formular on a Delta (between actual and target) that I have already calculated in the model.

IF([Delta]>=0,1 ,0)

  1. Meet/exceeded

0- Missed target

Idea was then to simply aggregate this figure.

But as it turns out you cannot aggregate formular based fields.

So how do I cover my requirement?

Many thanks in advance and best regards,

Axel

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers