Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
with the formula max(Fact.Date_Ordered) I can calculate the date of the last order.
How can I calculate the value of the last Order?
The formula to calculate the revenue is sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR))
Thanks for your help
Use FirstSortedValue(), like:
FirstSortedValue( Aggr(sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR)), Date) , -Date)
sum({<Fact.Type = {'Sales'}, Fact.Date_Ordered = {"=$(=max(Fact.Date_Ordered))"}>}Fact.Net_Rev_EUR))
try this and let me know
sum({<Fact.Type = {'Sales'}, Fact.Date_Ordered = {'$(=max(Fact.Date_Ordered))'}>}Fact.Net_Rev_EUR))
Unfortunately all 3 suggestions doesn't work...
As Dimension I have "Customer_Sales.Name" in the Table.
can you attach a sample app