My client wants to get the vendor wise USD total amount till date.
Thanks in Advance,
Helpful Answers will be marked.
It is a direct request....
Drag Vendor Sum(Amount) Date and run the report,to display the amount in Dollars u can go to colounproperties----Dataformat----Check Option Override as default data format-----Treat number as Currency.....
Mark as correct if it is helpful.
Use Todate Time series funtion.
Ex:ToDate("Sample".Fact"."Amt", "Sample"."Period"."Year" )