This content has been marked as final.
Show 2 replies
-
1. Re: Cannot mix aggregate and non aggregate.
Joe OppeltMay 18, 2016 2:11 PM (in response to angelo martinez)
One of those fields is an aggregate. Probably [TotalDias].
If so, then do this:
IF attr([Number Of Real Wager]) > 0 AND
[TotalDias] < 15 THEN 'Activo'
ELSEIF attr([Number Of Real Wager]) > 0 AND
[TotalDias] >= 15 THEN 'Inactivo'
ELSE
'Nunca uso'
END
If [Number of Real Wager] is the aggregate, then enclose [TotalDias] in ATTR() instead.
-
2. Re: Cannot mix aggregate and non aggregate.
Derrick Austin May 18, 2016 2:11 PM (in response to angelo martinez)Hello Angelo,
It's hard to tell from the formula, but it seems that one of the fields is aggregated and the other is not.
It is possible that wrapping ATTR() around the one that is not would fix the issue.
Another thought might be LoD calculations, for example:
IF [Number Of Real Wager] > 0 AND
{FIXED [Customer] : [TotalDias]} < 15 THEN 'Activo'
...
Hope this helps!