Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the following formula in textfield that should give the number of DimensionToCount on the day that is before the selected day (or month):
count(if (InDay (Date, vDateToAnalyse, -1), DimensionToCount))
vDateToAnalyse: DayName (max(Date), 0)
That returns the correct number if I have no selection. But if I choose another day and want to see the Value of the day before, I get "0" because of the selection.
I thought something like that could be the solution: count({1}if (InDay (Date, vDateToAnalyse, -1), DimensionToCount))
But that Returns the wrong value. Does anyone have an idea how to solve this problem?
Many thanks in advance
Agathe
Hello!
Add
vDateToAnalyse: DayName (max({1}Date), 0)
Thanks a lot for your reply.
I tried your suggestion, but that leads to the Problem, that the date is fix to the max date. But in the formula I want to have a variable date in relation to the selection.
Best regards
Agathe
Try like:
count({<Date={'$(=Date(Max(Date)-1))'}>} DimensionToCount)
If this doesn't work, try to share a samplw qvw.
Hi,
sorry for waiting so long, but many thanks to you for your answer.
Unfortunately your Suggestion didn´t work. :-(.
I created an example:
For last month try:
=count({<Month={'$(=Month(AddMonths(Max(Date),-1)))'}>} Employee)
That showed a number in the demo but unfortunately not in my master file. I will try it otherwise but many thanks for your help.