Forum Discussion
Measure Calculations decimal point
Hi team,
Here I am trying to calculate the measure value TCS_AMT. The following is the query that we have used in DB.
Sum((
(Nvl(Nvl(T502.C502_Ext_Item_Price,T502.C502_Item_Price),0) * Nvl(T502.C502_Item_Qty,0))+
((Nvl(Nvl(T502.C502_Ext_Item_Price,T502.C502_Item_Price),0) * Nvl(T502.C502_Item_Qty,0))* Nvl(T502.C502_Igst_Rate,0)/100) +
((Nvl(Nvl(T502.C502_Ext_Item_Price,T502.C502_Item_Price),0) * Nvl(T502.C502_Item_Qty,0))* Nvl(T502.C502_Cgst_Rate,0)/100) +
((NVL(NVL(t502.c502_ext_item_price,t502.c502_item_price),0) * NVL(t502.c502_item_qty,0))* NVL(t502.c502_sgst_rate,0)/100)) * Nvl(T502.C502_Tcs_Rate,0)/100) As TCS_AMT
The calculation that I used in power BI Desktop was
Created all the measures for IGST,GST,CGST .We are expecting the value for the TCS_AMT ="5015.775" and we are not supposed to use 1000 divider for the above formula.Could anyone of you please let me know the solution for this.
1 Reply
Hi achanikya
Thanks for reaching out to us.
you can try something like this powerbi - How to conditionally display decimals in a measure in Power BI - Stack Overflow
FORMAT([SimpleMeasure], "#,##0")or select that measure and
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
