Show the amount until selected Month in parameter
-
Hi all,
I wish display the amount of my groupings not for all months (second picture) of the year(in columns of the tablix) but only for the months prior to the month selected in parameter(first picture)
In terms of amount, when I used this expression
=Format(IIF(Fields!Mois.Value <= Parameters!DimDateMois.Label(0), Fields!Montant_Réalisé.Value, nothing), "### ### ###.00")This expression return empty cells for all months
And when i replace "<=" whith ">" the result is :
=Format(IIF(Fields!Mois.Value > Parameters!DimDateMois.Label(0), Fields!Montant_Réalisé.Value, nothing), "### ### ###.00")
Do you have any ideas please?
-
Looks like you are using .LABEL(0) from the parameter. This will return a text value. The DimDateMois.value is probably a number. Try :
=Format(IIF(Fields!Mois.Value <= cint(Parameters!DimDateMois.Label(0)), Fields!Montant_Réalisé.Value, nothing), "### ### ###.00")
Fitz
-
Hi Fitz,
Thank you very much for your response.
I get the expected result.
By cons I have a problem with the totals:
the term I use is as follows:
= Format (Sum (Fields! Montant_Réalisé.Value), "# # # # # # # # # .00")
-
m.eddakri (10/15/2013)
Hi Fitz,Thank you very much for your response.
I get the expected result.
By cons I have a problem with the totals:
the term I use is as follows:
= Format (Sum (Fields! Montant_Réalisé.Value), "# # # # # # # # # .00")
Yes you will have as the SUM does not knwo about the showing / hidden values. Try
=Format(Sum (IIF(Fields!Mois.Value <= cint(Parameters!DimDateMois.Label(0)), Fields!Montant_Réalisé.Value,0)), "### ### ###.00")
As this will only sum the values that are shown.
Fitz
-
perfect, thank you very much Fitz
It works very well. you have been to me a lot of help
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply