Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to make the below logic as static..like it wont reflect as per any filter selection.
num(((sum({$<AuditDate={'>=$(VSSSCurrMonthStart)<=$(vSSSYesterday)'}>}TOTAL PostedSales)
-
sum({$<AuditDate={'>=$(VSSSLastMonthStart)<=$(vSSSYesterdayLY)'}>}TOTAL PostedSales))
/
sum({$<AuditDate={'>=$(VSSSLastMonthStart)<=$(vSSSYesterdayLY)'}>}TOTAL PostedSales)),'#.##%')
Thanks..
May be this:
Num(((Sum({1<AuditDate={'>=$(VSSSCurrMonthStart)<=$(vSSSYesterday)'}>}TOTAL PostedSales)
-
Sum({1<AuditDate={'>=$(VSSSLastMonthStart)<=$(vSSSYesterdayLY)'}>}TOTAL PostedSales))
/
Sum({1<AuditDate={'>=$(VSSSLastMonthStart)<=$(vSSSYesterdayLY)'}>}TOTAL PostedSales)),'#.##%')
You may also need to make the same modification within your variables if those are expressions too.
UPDATE: Would be able to share some details about those 6 variables?
May be this:
Num(((Sum({1<AuditDate={'>=$(VSSSCurrMonthStart)<=$(vSSSYesterday)'}>}TOTAL PostedSales)
-
Sum({1<AuditDate={'>=$(VSSSLastMonthStart)<=$(vSSSYesterdayLY)'}>}TOTAL PostedSales))
/
Sum({1<AuditDate={'>=$(VSSSLastMonthStart)<=$(vSSSYesterdayLY)'}>}TOTAL PostedSales)),'#.##%')
You may also need to make the same modification within your variables if those are expressions too.
UPDATE: Would be able to share some details about those 6 variables?
write 1 instead of $ in set analysis.
or
try with nullify user possible selections
Regards
Thanks..it working fine