Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I tried to create a diagram that shows daily sales in the current month without having the current month selected.
I entered following formular in Dimensions / Conditions, etc.
=month(today()) = Month(Fact.Date_Invoiced)
why does it not work?...mmmmmh
Thanks for your help
Oliver
Dear,
Take Fact.Date_Invoiced as dimension.
and in Expression you can include the set analysis to filter the data for current month.
if it's not clear than attach the sample file so that we can help you.
Thanks,
Mukram.
Please provide some example.
Hi,
Check if this helps.
If not, Try to post sample data with expected output to get exact output.
Regards
ASHFAQ
Hi all
sorry, I don't understand why this is not working. Added a short test file...
Thanks for your help.
Oliver
Hi,
Try like this
=Sum({<Fact.Date_Invoiced = {'$(=date(Max(Fact.Date_Invoiced)))'}>} Fact.Net_Rev_EUR)
This was your expression
=Sum({<Fact.Date_Invoiced = {'$(=Max(fact.Date_invoiced))'}>} Fact.Net_Rev_EUR)
Set Analysis is case sensitive.
Your field Fact.Date_Invoiced does not match with {'$(=Max(fact.Date_invoiced))'
Have a look at attached application too.
Regards
ASHFAQ
Hi,
You have to write because some field name missing try this
=Sum({<Fact.Date_Invoiced = {'$(=date(Max(Fact.Date_Invoiced)))'}>} Fact.Net_Rev_EUR)
Regards
Anand
Hi all
Thanks for your help.
Now I get the revenue of the max day, but I want it of the max month per day...
=Sum({<month(Fact.Date_Invoiced) = {'$(=date(Max(Month(Fact.Date_Invoiced))))'}>} Fact.Net_Rev_EUR)
this does'nt work, the result is 0
Hi,
Can you close this thread and open new one for another request.
Regards
ASHFAQ
Why, still looking for "Daily Sales of current month without month selection"...and the solution is close but not there, yet!