Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a table with an YTD (year to date) expression. This works greate.
But I want to show a message if no date is slected, because in this case the table is empty.
At the moment i use this for calculating my ytd:
sum({<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} AmountofOrder)
If no date is selected it looks like this:
In this Case I want to display the Message "Please select a Year and Month"
How could I do that?
Many Thanks for your efforts.
Philipp
Go to the Properties | General tab and enter an expression into the conditional calculation box. Something like:
GetSelectedCount(Year) > 0 And GetSelectedCount(Month) > 0
This will cause a Calculation condition unfulfilled error to appear if there is no Year or no Month (or neither) selected. Change this error message to a more relevant one by clicking Error Messages, select Calculation condition unfulfilled and type your desired error messge.
If Year and Month are not the correct field names, change the expression above to the correct field names.
Go to chart general tab then write conditional expression and write the error message what you want
Go to the Properties | General tab and enter an expression into the conditional calculation box. Something like:
GetSelectedCount(Year) > 0 And GetSelectedCount(Month) > 0
This will cause a Calculation condition unfulfilled error to appear if there is no Year or no Month (or neither) selected. Change this error message to a more relevant one by clicking Error Messages, select Calculation condition unfulfilled and type your desired error messge.
If Year and Month are not the correct field names, change the expression above to the correct field names.
Ok I understand,
but what is the condition for that, and where and how can I do that... can you please give me more details?!
define in calculation condition like
=if((GetSelectedCount(yourryearfield) > 0) AND (GetSelectedCount(yourmonthfield) > 0),-1,0)
and Change error message for "calcualation condition unfilled" to "Please select a Year and a Month)
Thank you for the help, but but somehow I do not understand it complete.
This is what I have done:
Then I wrote this:
The name of the Fields is correct, but I do not know what you mean with
Go to the Properties | General tab and enter an expression into the conditional calculation box. Something like:
This will cause a Calculation condition unfulfilled error to appear if there is no Year or no Month (or neither) selected. Change this error message to a more relevant one by clicking Error Messages, select Calculation condition unfulfilled and type your desired error messge.
My Mistake...
But finally I found it.
Thank you so much!!
Your earlier post refers:
No, that expression must be entered in the 'Calculation Condition' box from your first screen shot.
Then enter the message that should appear when the condition is not me in the box in the second screen shot. But select the "Calculation condition unfulfilled" standard message before entering your custom message.