Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Max Year works for this Expression
(Sum({<CloseAdmin_Year={$(=Max(Year))},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year))}>} NET_INDEMNITY_PAID)+
Sum({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max(CloseAdmin_Year)'},Month = {
"<=$(=Max(Month))"}>} NET_INDEMNITY_PAID))
/(Count({<CloseAdmin_Year={$(=Max(Year))},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year))}>} distinct
[Claim No])+
Count({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max(CloseAdmin_Year)'},Month = {"<=$(=Max(Month))"}>} DISTINCT [Occurence No]))
But not working for MAx(Year)-1,
=(Sum({<CloseAdmin_Year={$(=Max(Year)-1)},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year)-1)}>} NET_INDEMNITY_PAID)+
Sum({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max((CloseAdmin_Year)-1)'},Month = {
"<=$(=Max(Month))"}>} NET_INDEMNITY_PAID))
/
(Count({<CloseAdmin_Year={$(=Max(Year)-1)},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year)-1)}>} distinct [Claim No])+
Count({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max((CloseAdmin_Year)-1)'},Month = {"<=$(=Max(Month))"}>} DISTINCT [Occurence No]))
Any Clues
Add a more brackets.
See underscore.
=(Sum({<CloseAdmin_Year={$(=(Max(Year)-1))},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=(Max(Year)-1))}>} NET_INDEMNITY_PAID)+
Sum({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=(Max((CloseAdmin_Year)-1))'},Month = {
"<=$(=Max(Month))"}>} NET_INDEMNITY_PAID))
/
(Count({<CloseAdmin_Year={$(=(Max(Year)-1))},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=(Max(Year)-1))}>} distinct [Claim No])+
Count({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=(Max((CloseAdmin_Year)-1))'},Month = {"<=$(=Max(Month))"}>} DISTINCT [Occurence No]))
Best Regards.
Tonial.
Doesnt Work, any more ideas pls
Have you tried Max(Year -1)
Yes I did
can u try this add '$(=(Max(Year)-1))'
Sum({<CloseAdmin_Year={'$(=(Max(Year)-1))'},
If Year is a dimension on your chart, it's not going to work.
No Dimenion is the Month