Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have a strange issue on amount conversion like ! ! FullAmount,Lacs etc.
Lets check below scenario.
I have inline table for amount conversion.
Load*, Amount_Selection as [_Amount_Selection];
AmountSelection:
LOAD * INLINE [Amount_Selection, Amount_Number
FullAmount,1
Lacs,100000
Million,1000000
];
And lets take some data.
LOAD * INLINE [
Store, Period, Sales
A, 4/1/2017, 2000000
A, 5/1/2017, 1500000
A, 4/30/2017, 6500000
A, 10/1/2017, 3000000
A, 12/1/2017, 5800000
B, 5/2/2017, 1000000
B, 4/30/2017, 5300000
B, 1/1/2018, 9800000
];
now I have this chart as follows-
in First Column I have sales amount from 1-4-2017 to 1/1/2018
=sum({<Period={">=$(vFinStart)<=$(vMonthEnd)"},Period=>}Sales)/Amount_Number
this means It will show each month sale amount in fullamount,Lacs etc.
But In this case Total sale matching, but except last row all month data showing null.
Second column: if I write sale amount/1 this is working. But I can not use this I need flexible selection of Amount.
=sum({<Period={">=$(vFinStart)<=$(vMonthEnd)"},Period=>}Sales)/1
Third Column: If I write sum(sale amount)/sum({<Period=>}Amount_Number) this is working.
=sum({<Period={">=$(vFinStart)<=$(vMonthEnd)"},Period=>}Sales)/sum({<Period=>}Amount_Number)
But I have 200 Reports I can't change the expression in all reports.
Is there any way to resolve this??
Thanks in Advance!
Hi Susovan,
As per your solution, I don't have to change in each & every expression.
Just create a variable and it's done..
Thanks!!!!