Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guru's,
I want to display Labels for my Combo chart are :<ok,0-10k,10-100k,100K-1M,1M+
how to achieve this using Class function
Please find the attached screen shot and Qvw
Thanks,
Raj
Try this instead of Class()
=Aggr(
If(Sum(Invoices) < 0, Dual('< 0', 1),
If(Sum(Invoices) < 10000, Dual('0-10k', 2),
If(Sum(Invoices) < 100000, Dual('10-100k', 3),
If(Sum(Invoices) < 1000000, Dual('100k-1M', 4), Dual('1M+', 5)))))
, [Invoice Number])
Try this instead of Class()
=Aggr(
If(Sum(Invoices) < 0, Dual('< 0', 1),
If(Sum(Invoices) < 10000, Dual('0-10k', 2),
If(Sum(Invoices) < 100000, Dual('10-100k', 3),
If(Sum(Invoices) < 1000000, Dual('100k-1M', 4), Dual('1M+', 5)))))
, [Invoice Number])
check sample age bucket
Hi Sunny ,
Thanks for your time.
in place of Sum (Invoices) i have expression as below
sum({<
[Invoices.TRANSACTION_COMPLETE_FLAG]={'Y'}
>} [USD_Invoices.DISTRIBUTION_AMOUNT])
+
sum([EuticalsInvoices.Value Invoiced $])
+
sum([GadeaDP.FA Base USD])
How to use this in expression
Thanks,
raj
May be this
=Aggr(
If(
RangeSum(Sum({<[Invoices.TRANSACTION_COMPLETE_FLAG]={'Y'}>} [USD_Invoices.DISTRIBUTION_AMOUNT]),
Sum([EuticalsInvoices.Value Invoiced $]),
Sum([GadeaDP.FA Base USD])) < 0, Dual('< 0', 1),
If(
RangeSum(Sum({<[Invoices.TRANSACTION_COMPLETE_FLAG]={'Y'}>} [USD_Invoices.DISTRIBUTION_AMOUNT]),
Sum([EuticalsInvoices.Value Invoiced $]),
Sum([GadeaDP.FA Base USD])) < 10000, Dual('0-10k', 2),
If(
RangeSum(Sum({<[Invoices.TRANSACTION_COMPLETE_FLAG]={'Y'}>} [USD_Invoices.DISTRIBUTION_AMOUNT]),
Sum([EuticalsInvoices.Value Invoiced $]),
Sum([GadeaDP.FA Base USD])) < 100000, Dual('10-100k', 3),
If(
RangeSum(Sum({<[Invoices.TRANSACTION_COMPLETE_FLAG]={'Y'}>} [USD_Invoices.DISTRIBUTION_AMOUNT]),
Sum([EuticalsInvoices.Value Invoiced $]),
Sum([GadeaDP.FA Base USD])) < 1000000, Dual('100k-1M', 4), Dual('1M+', 5)))))
, [Invoice Number])