
1. Re: Calculated Field with different field dates
Mahfooj Khan Aug 14, 2018 4:40 AM (in response to Jose Daniel Moreira)1 of 1 people found this helpfulHi,
I didn't find any mistake in your calculation, however you just need to use aggregate function on your calculated measure like this
Use MIN() on your existing calculation
Hope this will help.
Mahfooj

2. Re: Calculated Field with different field dates
Jose Daniel Moreira Aug 14, 2018 5:59 AM (in response to Mahfooj Khan)HI Mahfooj,
OMG! I can´t not believe you got it with the same formula. First thanks very much for replying. I´m missing something because
I´m as you suggested using the MIN function in the Calculation. On the other hand I tried to use the
SUM fuction on both sides because makes a lot of sense, but no luck.Did you change something in the Calculated Field?
Thanks for the time and the helpBR

3. Re: Calculated Field with different field dates
Mahfooj Khan Aug 14, 2018 8:37 AM (in response to Jose Daniel Moreira)1 of 1 people found this helpfulEarlier I tried with SUM() but that was not giving the correct result so I edited my reply.
Here I've used your formula and include [Name Orgn Ctgrs] dimension in the formula and using MIN() aggregation.
[Name Orgn Ctgrs] field is optional though I included because you've used it in your view. So that results gets computed properly.
Hope this will help.
Mahfooj

4. Re: Calculated Field with different field dates
Jose Daniel Moreira Aug 20, 2018 1:56 AM (in response to Mahfooj Khan)Efectively Mahfooj,
Adding the [Name Orgn Ctgrs] dimension to the formula was the solution.
Thanks very much. I marked the answer as correctCan I ask one more thing, Is regarding the display of the information. As you can see I have
"Income Source", this is displaying by a MIN calculation, because its a FIXED table, to display the correct number I have to add "Product" and "Source" dimensions, otherwise will display the MIN number of a lowerlevel of agregation, so it will exclude a lot of numbers in the calculation.
My question is: How can I display the result of the SUM of a MIN calculation. In this case I want to show
the SUM of "Book Income" of the "Name Orgn Ctgrs". Example:Hopefully you got the idea of the question.
And again, thank you very much for the help.BR

5. Re: Calculated Field with different field dates
Jose Daniel Moreira Aug 20, 2018 3:50 AM (in response to Jose Daniel Moreira)I get the result using the same formula, and allowed me to go to different detail level.
{FIXED DATEPART ("month", [Date]), [Source], [Product], [Name Orgn Ctgrs] : MIN (Book Income)]}